SimonBarrington Posted May 10, 2021 Share Posted May 10, 2021 I have a worksheet in a document to count up fencing requirements for a festival site. I have done a line type for each type of fencing, and created a record so I can easily give the lines a name to relate to the area Column A gives me the length of each line, rounded up to the nearest metre. Column B works out the number of Panels, and Column C shows the areas (which is achieved by going the information from the record. This is shown in the first image When I try to Summarize the area's in that column so I don't have so many rows that essentially repeat the same area name, I lose a load of information as shown in the second image. What am I doing wrong? Quote Link to comment
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.