SUMIF with criteria text (string)

**jcprata** · 11-20-2009, 11:02 AM

Hi,

Is this criteria of SUMIF correct:

Please Login or Register  to view this content.

I want to SUM the values from Q22 cells range, if the text in A22 is equal to "zEz" or different of "zEz" (i want this two cases, equal and diferent)

Best Regards,
JP.

**DonkeyOte** · 11-20-2009, 11:06 AM

You're referencing only one cell so you could just use

Match
=Q22*(A22="zEz")

Non Match
=Q22*(A22<>"zEz")

Of course you could just subtract the first calculation from the value of Q22 for the Non-Match total

In terms of Syntax for the SUMIF yes you're formulae are correct (assuming you're not conducting partial matches) though technically you do not require the = operator in the 2nd formula.