| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM, IF, OR, AND array
I am seeking a formula for the following:
On 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 add all corresponding numbers in Chart1!$AV$2:$AV$7500. thanks in advance, Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Goal Seek On Members of an Array within Array | Excel Worksheet Functions | |||
Threaded Mode
