SUMIF(NOT)
 

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

SUMIF(NOT)
 

Maybe something like this:

=SUMIF(E4:E20,"<rejected",D4:D20)

< means not equal

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

Biff

"Kigol" wrote in message
oups.com...
Can you include NOT in a SUMIF criteria? It doesn't seem to be working
for me, any suggestions?

SUMIF(NOT)
 

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

"Kigol" wrote in message
oups.com...
Can you include NOT in a SUMIF criteria? It doesn't seem to be working
for me, any suggestions?

SUMIF(NOT)
 

On May 29, 2:01 pm, "Don Guillett" wrote:
"<"&"joe"
--
Don Guillett
SalesAid Software
"Kigol" wrote in message

oups.com...



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

- Show quoted text -

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

SUMIF(NOT)
 

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)
--
Don Guillett
SalesAid Software

"Kigol" wrote in message
ups.com...
On May 29, 2:01 pm, "Don Guillett" wrote:
"<"&"joe"
--
Don Guillett
SalesAid Software
"Kigol" wrote in message

oups.com...



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

- Show quoted text -

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