I have the following formula in Excel 2007 posted in cell M199:
....whereby Row197 represents a flipped input, and Row 192 equals the month in my timeline.
The formula works successfully and does what it is supposed to do. However because of the length of the sumproduct (i.e from column M to GJ) and the number of rows (this goes down a few '000 rows) my spreadsheet is enormous (100mb). Also it takes some time to recalculate.
I was wondering if anyone could think of an alternative formula, perhaps using dynamic range names, which would eliminate the need for so many SUMPRODUCTS, or at least speed up my spreadsheet?
Many thanks for any help you can offer