Hi

Can anyone tell me if the SumIf function can work with 2 different sets of
criteria.

eg:

A1 = P B1 = M C1 = 20
A2 = P B2 = M C2 = 10
A3 = U B3 = M C2 = 10

I would like a formula to sum the C column numbers based on if the A column
returns the letter U and the B column returns the letter M.

But return a zero if the A column returns the letter P and the B column
returns the letter M.

I can get half way there using the SumIf function but I can't get a 2nd
criteria in the formula.

I run Excel 2000

Any help would be much appreciated