Hello!
I have monthly financial data with the months across the row and the financial metrics down the column. I need to aggregate these months into quarterly, annual, or quarterly/annual displays for the user. I wrote formulas to generate the correct headings based on the user selection. But when I wrote the formulas using sumproducts as a two dimensional sumif, the workbook slowed down too much (there was roughly a 1 second delay between pressing enter and Excel responding). Does anyone have ideas on how to structure this aggregation? Currently I have built a tab that pulls the data with index(match(match in the exact layout that I need to aggregate the data and then I'm using sumifs on the rows. But I'd prefer it to sum based on matching the row name and not a direct row reference.
Any insight?
Thanks!
I have monthly financial data with the months across the row and the financial metrics down the column. I need to aggregate these months into quarterly, annual, or quarterly/annual displays for the user. I wrote formulas to generate the correct headings based on the user selection. But when I wrote the formulas using sumproducts as a two dimensional sumif, the workbook slowed down too much (there was roughly a 1 second delay between pressing enter and Excel responding). Does anyone have ideas on how to structure this aggregation? Currently I have built a tab that pulls the data with index(match(match in the exact layout that I need to aggregate the data and then I'm using sumifs on the rows. But I'd prefer it to sum based on matching the row name and not a direct row reference.
Any insight?
Thanks!