| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to total like items
I have a spreadsheet where I need to total certain sections. I use it to
total hours for each loaction. Some locations have multiple lines while others only have one. How can I create a grand total for the locations with more than one entry? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to total like items
Hi Cosmo
Have a look at Data/Subtotals You can nominate where you want the subtotals to appear HTH Michael "Cosmo" wrote: I have a spreadsheet where I need to total certain sections. I use it to total hours for each loaction. Some locations have multiple lines while others only have one. How can I create a grand total for the locations with more than one entry? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to total like items
Thank You Very Much!
"Michael M" wrote: Hi Cosmo Have a look at Data/Subtotals You can nominate where you want the subtotals to appear HTH Michael "Cosmo" wrote: I have a spreadsheet where I need to total certain sections. I use it to total hours for each loaction. Some locations have multiple lines while others only have one. How can I create a grand total for the locations with more than one entry? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Erroneous Grand Total of calculated fields in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Total TIme worked | Excel Worksheet Functions | |||
| show in a excel graphic a total percentage for 5 diff data fiels | Charts and Charting in Excel | |||
| @SUM Total Changes | Excel Worksheet Functions | |||
Hybrid Mode
