Hello,
I have the following formula which works in my current excel spreadsheet, but it is calculating very slowly. The named ranges are single columns (it references the entire column but only has ~10k rows with data for now). The formula is repeated hundreds of time on the slow tab by varying the row referenced in '$A9' and the first part of the sumproduct 'FGA_Adj'.
Is there another way to write this using a sumif(s) or some other efficient way? I have read that a sumif would be a much more computationally efficient solution.
Thanks,
Mark
Bookmarks