Multiple SumIf Formula

R

Rose

I need a formula allowing recognition of one response in
Cell A in addition to recognising if the answers in cell B
equals either x, y or z then add up the total values.

I understood the inclusion of the "+" symbol should allow
this but my query parameters are not working. Eg:

=SUM(IF(A5:A30="JUL",IF(D5:D30="HSP3")+
(D5:D30="HSP1",C5:C30))

So with this formula cells A should equal Jul and cells D
have either HSP3 or HSP1.

Thanks.
 
A

Aladin Akyurek

Invoking a SumProduct formula...

=SUMPRODUCT(--(A5:A30="JUL"),(D5:D30="HSP3")+(D5:D30="HSP1"),C5:C30)

which just needs enter.
 
Top