need help quickly!!

A

alexm999

I have a spreadsheet that has in column I a state abreviation. (NE, MA,
etc...). In column G I have a number of subscribers. I'd like a report
formula that adds up all the numbers associated with a specific state.

I'm doing it manually now and it's a pain! help!
 
S

SteveG

You can use SUMPRODUCT.

=SUMPRODUCT((A1:A100="MA")*(B1:B100))

Where A is your list of abbreviations and B are your numbers to sum.
Rather than type the abbreviation in the formula, you could have a dro
down list with all state abbreviations and have your formula refer t
that cell say C1. Then you could just select a state abbreviation fro
the list and the formula would return the value for that abbreviation.


=SUMPRODUCT((A1:A100=C1)*(B1:B100))

Does that help,

Stev
 
D

davesexcel

=SUMIF(A1:B5,C1,B1:B5)
A1:B5 is the range
C1 is the Crieteria
B1:B5 adds up the numbers that meet the criteria
 
Top