Sum cells based on value of other cells

[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

 

[Ron Coderre]

Try something like this:

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

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

Regards,

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

 

[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)

 

[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)

 

[T. Valko]

You're welcome. Thanks for the feedback!