| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotals / Grand Total
This should be so simple but I cant figure out how to get a Grand Total cell
B16 without naming each sub total cell. I used 'auto sum' icon to get a subtotal on b5, b10, b14. Help lost me on paste functions, math, sum because I got a sum that included the sub totals as another entry. Obviously I am a very new Excel user. TIA Col A Col B Mr. Smith January 5.00 February 6.00 March 7.00 18.00 ABC Co January 15.00 February 20.00 35.00 DEF Co January 10.00 10.00 Grand Total ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grand total subtotals without hiding details | Excel Worksheet Functions | |||
| Help, add subtotals included in one column to get a grand total | Excel Discussion (Misc queries) | |||
| Removeing the Grand Total Line when subtotals are removed | Excel Discussion (Misc queries) | |||
| show only the subtotals and grand total in a pivot table | Excel Worksheet Functions | |||
| grand-total of subtotals ? | Excel Worksheet Functions | |||
Threaded Mode
