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
 

See your other post

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

multiple ranges & criteria for SUM-IF challenge
 

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

--
*****
birds of the same feather flock together..



"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

multiple ranges & criteria for SUM-IF challenge
 

potentially
=sumproduct(--(A5:A10=P5),--(B5:B10=Q5),--(C5:C10=R4),--(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

multiple ranges & criteria for SUM-IF challenge
 

=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