SUMIF with AND and OR

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I am trying to create a table and need a formula that will
do the following.

SUMIF H3:H300 OR I3:I300 = C4 AND D3:D300 = A5

Thanks in Advance.
 
I don't see from this what would be summed..

You can get started with sumproduct;

=SUMPRODUCT((H3:H300=C4)*(I3:I300=C4)*(D3:D300=A5),X3:X300)

where x3:x300 is the range you want summed.
 
Not sure I understand what you require, try this and post back if its not
what you need,
=SUMPRODUCT((H3:H300=C4)*(I3:I300=C4)*(D3:D300=A5))
Regards,
 
Hi Carl
another alternative
=SUMPRODUCT(((H3:H300=C4)+(I3:I300=C4)>0)*(D3:D300=A5),range_to_sum)
 
Back
Top