Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding text to the subtotal row
I have this sample data:
Project # City State Address Department Staff 1 Phoenix AZ 123 Fake Street HR 3 1 Phoenix AZ 123 Fake Street Legal 2 2 Phoenix AZ 123 Fake Street IT 7 3 Phoenix AZ 999 Square Ave. HR 2 3 Phoenix AZ 999 Square Ave. IT 1 3 Phoenix AZ 999 Square Ave. Sales 4 I need to subtotal by Project and sum all staff, but I need to have the Address show up on the subtotal row. Is there an easier way of doing this than copy/paste, considering my actual data includes ~500 projects, and some addresses have multiple projects (so I can't subtotal by address)? Thanks, officewrkr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel subtotal function- put subtotals in bold text | Excel Discussion (Misc queries) | |||
Pivot Table-change Subtotal text? | Excel Discussion (Misc queries) | |||
Need subtotal function to return text as result | Excel Discussion (Misc queries) | |||
adding IF statement to subtotal for autofiltered data | Excel Worksheet Functions | |||
how can i subtotal on a text value - ex. every Monday? | Excel Worksheet Functions |