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
 
G

Guest

hello aku,
i can see some sense in the data, is it R4 or R5 for a pattern of criteria ?
regards,
driller
 
G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to put quotes in a SUMIF formula and when is & used for cell 2
Index/Match maybe??? 10
Sum If - How to sum for ranges meeting certain criteria 1
Data Entry Form - Execute if value is not 0 5
LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
complex count formulas using multiple criteria in different ranges 4
change cell color depending on two cell values 1
How to simplify If / ElseIf statement 4

Top