On Sep 26, 12:28 pm, officewrkr <officew...@discussions.microsoft.com>
wrote:

after you do the subtotal from the subtotal function add the address
as follows:
=SUBTOTAL(9,f14:f15)&"    "&d14

the final should look like this

A    B    C    D        E    F
Project #     City     State    Address                Department        Staff
1    Phoenix      AZ    123 Fake Street     HR    3
1    Phoenix      AZ    124 Fake Street     Legal    2
1 Total                    5    123 Fake Street
2    Phoenix      AZ    125 Fake Street     HR    7
2 Total                    7    125 Fake Street
3    Phoenix      AZ    126 Fake Street     Legal    2
3    Phoenix      AZ    127 Fake Street     HR    1
3    Phoenix      AZ    128 Fake Street     Legal    4
3 Total                    7    128 Fake Street
Grand Total                    19
6