multiple ranges & criteria for SUM-IF challenge
 

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

multiple ranges & criteria for SUM-IF challenge
 

Try this:

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

Biff

"akumudzi" wrote in message
oups.com...
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