| 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 |
| 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) | |||
| Array: Counting multiple values within 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
