Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |