Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a specific range
I am working in Microsoft Excel 2003. I am trying to sum certain ranges in
multiple lines of data. An example of my spreadsheet is below. The way it is now, the "END BALANCE" row is not including the amount in the CDU field (row 1 and 8). I need to be able to sum rows 1-5 with results on row 6 and then sum rows 8-14 with results on row 15, etc. Any ideas? A B C 1 NAME CDU 3.42 2 INCOME 1.31 3 BOND 1.29 4 BALANCED 5.42 5 LARGE-CAP 3.05 6 END BALANCE 11.07 7 0 8 NAME CDU 5.42 9 INCOME 6.31 10 BOND 18.29 11 BALANCED 53.42 12 LARGE-CAP 35.05 13 MID-CAP 2.00 14 WORLD 5.00 15 END BALANCE 120.07 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transfer specific range to another range ? | Excel Discussion (Misc queries) | |||
how many times a specific value is in a range...? | Excel Worksheet Functions | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
MEDIAN, STDEV of a range IF another range = specific value | Excel Worksheet Functions |