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
|