Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform summation over variable areas?
I work in an IT issue processing team, I want to do a report that has four
sections. The top section always has the same height and width, and displays summed values from the other three sections. These sums are broken down by issue category. The second section shows the detail of activity for the current day--issues opened today and outstanding from prior days. The third section shows issues that have been closed today The fourth section shows issues that have been closed from the beginning of the current week. All the sections have the same width, but obviously there will be different numbers of rows for sections 2, 3, and 4. By using hidden columns and the IF function, I can create a tally for each detail row that tells what category the issue should be counted under, but how do I handle the fact that there are different numbers of rows in each section from day to day? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I perform summation over variable areas?
unfortunately the best suggestions will depend on how you have your data
formatted. the pivot table or sumif()s if there is a good identifier in each line to indicate each section A macro might be needed to locate the spaces between the sections or to locate the header line in each section "Pithecanthropus" wrote: I work in an IT issue processing team, I want to do a report that has four sections. The top section always has the same height and width, and displays summed values from the other three sections. These sums are broken down by issue category. The second section shows the detail of activity for the current day--issues opened today and outstanding from prior days. The third section shows issues that have been closed today The fourth section shows issues that have been closed from the beginning of the current week. All the sections have the same width, but obviously there will be different numbers of rows for sections 2, 3, and 4. By using hidden columns and the IF function, I can create a tally for each detail row that tells what category the issue should be counted under, but how do I handle the fact that there are different numbers of rows in each section from day to day? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summation | Excel Worksheet Functions | |||
Summation of time | Excel Worksheet Functions | |||
perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
Summation from a to b | Excel Worksheet Functions | |||
How can perform a summation? | Excel Worksheet Functions |