SUM Problem

[LD]

Hi all.

Need help with a formula to sum certain criteria.
Spreadsheet with 12 columns.

Column B has different criteria ex. A,B,C etc.
Column H has amounts.

I need a formula to sum column H that matches all the criteria in column B.
Ex. Sum all the amounts where Column B = "C"

Thanx in advance.

 

[Frank Kabel]

Hi LD
for your example use
=SUMIF(B1:B999,"C",H1:H999)

HTH
Frank

 

[LD]

Never mind.
I got it.
Thanx anyway.