Help with adding columns for state totals

Closed
DONNAJ - Sep 1, 2017 at 07:40 PM
 Blocked Profile - Sep 1, 2017 at 08:15 PM
Hello,

I have a worksheet that shows clients (col A) by state(col B) with total spend (col E).

I have all states abbreviation in col H and would like the total for each state from col E to tally into col I.

COL A COL B COL E
client 1 OK $200
client 2 CA $800
client 3 OK $2000
client 4 NJ $5000

Col H has all 50 states in alpha order
AK
AZ
CA
ETCETERA

How do I get the totals for each state into Col I?

Can you help?


Related:

1 response

Wow, this seems like homework?

We can help, but not with homework.

Why are YOU tasked with this? Job? Perhaps you have entered into what is known as the PETER-PRINCIPLE?


It's kind of fun to do the impossible! -Walter Elias Disney
0