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

"akumudzi" wrote:

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