K
Kigol
Can you include NOT in a SUMIF criteria? It doesn't seem to be working
for me, any suggestions?
for me, any suggestions?
T
T. Valko
Maybe something like this:
=SUMIF(E4:E20,"<>rejected",D4
20)
<> means not equal
So, sum D if E does not equal "rejected"
Biff
=SUMIF(E4:E20,"<>rejected",D4
20)<> means not equal
So, sum D if E does not equal "rejected"
Biff
D
Don Guillett
"<>"&"joe"
K
Kigol
Ah yes thank you very much. A little inclusion in the sumproduct
statement and I'm good to go. Thanks guys.
D
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)
sumproduct,something like:
=sumproduct((a2:a22<>"a")*b2:b22)
for sumif
=SUMIF(I2:K22,"<>a",J2:J22)
or
=SUMIF(I2:K22,"<>"&"a",J2:J22)