Hello,
I have a set of data where each column (except for the first) represent month and each row represent a unique data item. I need to select all rows and few columns that represent the months in a given date range (see cell B16 and B17). The end goal is to create an array of sums (see formula in cell B19) and plot that array in a graph...
I can use INDEX and MATCH function to select the required columns for 1 row (see formula in cell B20), but the same extended to multiple rows is failing (see formula in cell B21).
What am I missing?
-prabhu
I have a set of data where each column (except for the first) represent month and each row represent a unique data item. I need to select all rows and few columns that represent the months in a given date range (see cell B16 and B17). The end goal is to create an array of sums (see formula in cell B19) and plot that array in a graph...
I can use INDEX and MATCH function to select the required columns for 1 row (see formula in cell B20), but the same extended to multiple rows is failing (see formula in cell B21).
What am I missing?
-prabhu