sumproduct with multiple criteria

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

Hi, I have this formula

=SUMPRODUCT((C3:C56 = FALSE)*(D3:D56 = FALSE)*(P3:P56=TRUE)*G3:G56)
where C, D, and P are checkboxes.

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

Is there a way to do that?

Many Thanks,

Mar
 
Mark,

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

=SUMPRODUCT((C3:C56 = FALSE)*(D3:D56 = FALSE)*(P3:P56=TRUE)*G3:G56) -
SUMPRODUCT((P3:P56=TRUE)*H3:H56)

--
Regards,
Auk Ales

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