SUM, IF, AND, OR array
 

I am seeking a formula for the following:

From the current worksheet,
IF $B2 = Chart1!$L$2:$L$7500 OR Chart1!$N$2:$N$7500
AND
IF $A2 = Chart1!$C$2:$C$7500
AND
IF $C2 = Chart1!$B$2:$B$7500
then I want to sum all of the corresponding values in Chart1!$AV$2:$AV$7500

Thanks in advance,
Bob

SUM, IF, AND, OR array
 

Try this:

=SUMPRODUCT(--(Chart1!$B$2:$B$7500=$C2),--(Chart1!$C$2:$C$7500=$A2),--((Chart1!$L$2:$L$7500=$B2)+(Chart1!$N$2:$N$7500=$B 2)0),Chart1!$AV$2:$AV$7500)


--
Biff
Microsoft Excel MVP


"bob" wrote in message
...
I am seeking a formula for the following:

From the current worksheet,
IF $B2 = Chart1!$L$2:$L$7500 OR Chart1!$N$2:$N$7500
AND
IF $A2 = Chart1!$C$2:$C$7500
AND
IF $C2 = Chart1!$B$2:$B$7500
then I want to sum all of the corresponding values in
Chart1!$AV$2:$AV$7500

Thanks in advance,
Bob