Sumproduct with criteria

[sharky12345]

I'm using this to count values, (using Excel 2003);

=SUMPRODUCT(--(B34:B5000=B7),--(C34:C5000=Correspondence!A8))

How can I add a criteria? I want it to count as above but only if the item has the value of X10 in column M.

 

[Vidar]

I'm using this to count values, (using Excel 2003);



How can I add a criteria? I want it to count as above but only if the item has the value of X10 in column M.

Maybe (not tested):
=SUMPRODUCT(--(B34:B5000=B7),--(C34:C5000=Correspondence!A8),--(M34:M5000="X10"))

 

[sharky12345]

Perfect - thanks!

 

[Vidar]

You're welcome