SUMIF with AND and OR

[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 D3300 = A5

Thanks in Advance.

 

[Dave R.]

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

You can get started with sumproduct;

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

where x3:x300 is the range you want summed.

 

[Alan]

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)*(D3300=A5))
Regards,

 

[Frank Kabel]

Hi Carl
another alternative
=SUMPRODUCT(((H3:H300=C4)+(I3:I300=C4)>0)*(D3300=A5),range_to_sum)