Help with adding columns for state totals

Closed
DONNAJ - 1 Sep 2017 à 19:40
 Blocked Profile - 1 Sep 2017 à 20:15
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?


1 response

Blocked Profile
1 Sep 2017 à 20:15
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