Sum cells based on value of other cells

C

Chris

I've tried finding the answer for this by searching, but didn't have
luck.

I have a table where column "A" contains a single character or empty.
Column "B" has a dollar value. I need to sum all "B" cells where "A"
has a specific letter, but can't figure out the right way to do this.

Thanks in advance,
Chris
 
R

Ron Coderre

Try something like this:

=SUMIF(A1:A10,"A",B1:B10)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
T

T. Valko

Try this:

=SUMIF(A1:A100,"A",B1:B100)

Wiill sum column B where column A = "A".

Or, use a cell to hold the criteria:

D1 = A

=SUMIF(A1:A100,D1,B1:B100)
 
C

Chris

Worked perfectly, thanks!

Try this:

=SUMIF(A1:A100,"A",B1:B100)

Wiill sum column B where column A = "A".

Or, use a cell to hold the criteria:

D1 = A

=SUMIF(A1:A100,D1,B1:B100)
Click to expand...
 
Top