I am currently working on a financial model for a SaaS company. I created the following formula to calculate churned MRR (it can be slightly modified to calculate expansion and reduction MRR as well):
However, SUMPRODUCT makes the spreadsheet unusable and extremely slow. I am sure there is a "lighter" formula out there but I cant find anything that works.
I have managed to run everything else with SUMIFS.
Any help would be appreciated!