So for example...
In Column AN6:AN1063 I have a list of Cities with NF and F after the names. In Cell AO6:AO1063 I have Dollar Amounts
example
AN6:AN1063 AO6:AO1063
Albuquerque F -$258.16
Albuquerque F $264,166.81
Albuquerque F $18,107.28
Albuquerque F $2,352.53
Austin F $3,636.00
Austin F $579.43
Austin F $12,100.00
Austin F $124,664.69
Beaverton NF $1,425,875.81
Beaverton NF $195,266.05
Beaverton NF $84,152.53
What i need to have happen is in AA6 give me the subtotal of all instance with that city name. In this example
AA6 AA7
Albuquerque F $284,368.46
Austin F $140,980.12
Beaverton NF $1,705,294.39
it should be noted that i have over 60 cities in AN6:AN1063 with dollar amounts next to it.
I just need to subtotal all the offices amounts but one office may have 40 rows...I hope this makes sense!
In Column AN6:AN1063 I have a list of Cities with NF and F after the names. In Cell AO6:AO1063 I have Dollar Amounts
example
AN6:AN1063 AO6:AO1063
Albuquerque F -$258.16
Albuquerque F $264,166.81
Albuquerque F $18,107.28
Albuquerque F $2,352.53
Austin F $3,636.00
Austin F $579.43
Austin F $12,100.00
Austin F $124,664.69
Beaverton NF $1,425,875.81
Beaverton NF $195,266.05
Beaverton NF $84,152.53
What i need to have happen is in AA6 give me the subtotal of all instance with that city name. In this example
AA6 AA7
Albuquerque F $284,368.46
Austin F $140,980.12
Beaverton NF $1,705,294.39
it should be noted that i have over 60 cities in AN6:AN1063 with dollar amounts next to it.
I just need to subtotal all the offices amounts but one office may have 40 rows...I hope this makes sense!
