sumproduct with multiple criteria

[marksuza]

Hi, I have this formula

=SUMPRODUCT((C3:C56 = FALSE)*(D356 = FALSE)*(P356=TRUE)*G3:G56)
where C, D, and P are checkboxes.

However, in addition to that, I want to say if P356 = true subtrac
H3:H56.

Is there a way to do that?

Many Thanks,

Mar

 

[A.W.J. Ales]

Mark,

if I understand you correct, this is the formula you need :

=SUMPRODUCT((C3:C56 = FALSE)*(D356 = FALSE)*(P356=TRUE)*G3:G56) -
SUMPRODUCT((P356=TRUE)*H3:H56)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[marksuza]

thank