Excel Calculation help


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!
Who is Participating?
barry houdiniConnect With a Mentor Commented:
Why not use SUMIFS here too, it'll be much faster even referring to whole columns


regards, barry
You can try to limit your ranges. E:E looks at everything from E1 to E1,048,576. Try something like E1:E100000.

Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.