Multiple SumIf Formula

[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(D530="HSP3")+
(D530="HSP1",C5:C30))

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

Thanks.

 

[Ken Wright]

Take a look here at the SUMPRODUCT function. The syntax is easier to
understand (IMO) and there is no need to array enter.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Aladin Akyurek]

Invoking a SumProduct formula...

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

which just needs enter.