Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional sum on an array based on another array
here is the data:
Mon 01 02 03 04 05 06 07 08 09 10 11 12 Actual 10 23 40 50 65 Fcst 8 20 44 55 60 70 55 55 50 40 30 20 The actuals are entered on a month end. I need a formula to check the 'Actual' row for 0, and take the index and create a dynamic array of Fcst Row and get a sum of the forecast. In the above example, the actual is zero for 06, and need sum of Fcst row( 06:12), This will change for next month when actuals are entered for June. Help is apprecited much -- Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Conditional formatting based upon array | Excel Worksheet Functions | |||
Goal Seek On Members of an Array within Array | Excel Worksheet Functions |