multiple ranges & criteria for SUM-IF challenge

A

akumudzi

Not sure if this is the function for the job but I need to have SUMIF
compare values in multiple ranges/columns and add if the values match
in those columns
e.g.

if the
value in range A5:A10 = value in P5 and
value in range B5:B10 = value in Q5 and
value in range C5:C10 = value in R4 and
value in range D5:D10 = value in S5 and
value in range E5:E10 = value in T5
sum range being Z5:Z10

I hope this makes sense. Can clarify further on request.

Thanks
 
R

Roger Govier

Hi
Try

=SUMPRODUCT((A5:A10=P5)*(B5:B10=Q5)*(C5:C10=R4)*
(D5:D10=S5)*(E5:E10=T5)*Z5:Z10)
 
Top