SUMIF(NOT)

[Kigol]

Can you include NOT in a SUMIF criteria? It doesn't seem to be working
for me, any suggestions?

 

[T. Valko]

Maybe something like this:

=SUMIF(E4:E20,"<>rejected",D420)

<> means not equal

So, sum D if E does not equal "rejected"

Biff

 

[Don Guillett]

"<>"&"joe"

 

[Kigol]

"<>"&"joe"
--
Don Guillett
SalesAid Software





- Show quoted text -

Ah yes thank you very much. A little inclusion in the sumproduct
statement and I'm good to go. Thanks guys.

 

[Don Guillett]

I thought you said SUMIF instead of SUMPRODUCT....???? If
sumproduct,something like:
=sumproduct((a2:a22<>"a")*b2:b22)
for sumif
=SUMIF(I2:K22,"<>a",J2:J22)
or
=SUMIF(I2:K22,"<>"&"a",J2:J22)