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)


--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
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