add two criteria that should not be met to sumproduct

  • Thread starter Thread starter Diddy
  • Start date Start date
D

Diddy

Hi everyone,

I'm using the following

=SUMPRODUCT(--(Data!$C$2:$C$10000=$A6),--(Data!$S$2:$S$10000=1),--(Data!$K$2:$K$10000<>"N2"))

Which works beautifully but I also need to say that if k2:k10000 does not
equal N1 it shouldn't be counted as well.

Grateful for any help
 
Have you tried this:

=SUMPRODUCT(--(Data!$C$2:$C$10000=$A6),--(Data!$S$2:$S$10000=1) ,--
(Data!$K$2:$K$10000<>"N2"),--(Data!$K$­2:$K$10000<>"N1"))

?

Hope this helps.

Pete
 
Hi Pete,

sorry for the delay in replying - I've been up to my eyes with something else!

I'm getting strange results with that formula. Some are higher than the
expected and some lower.

Any suggestions

Many thanks
 
Well, I'm glad to hear that, Deirdre, although I had forgotten about
this particular post.

Pete
 
Back
Top