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