<div>
You can try to limit your ranges. E:E looks at everything from E1 to E1,048,576. Try something like E1:E100000.<br />
<br />
Flyster
</div>


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

Flyster

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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):<br />
<br />
=SUMPRODUCT((E:E=&quot;NAME&quot;)*(<wbr />AE:AE=0)*(<wbr />AD:AD&gt;0)*(<wbr />AD:AD))<br />
<br />
However, SUMPRODUCT makes the spreadsheet unusable and extremely slow. I am sure there is a &quot;lighter&quot; formula out there but I cant find anything that works.<br />
<br />
I have managed to run everything else with SUMIFS.<br />
<br />
Any help would be appreciated!
</div>
</div>


Hello,

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):

=SUMPRODUCT((E:E="NAME")*(AE:AE=0)*(AD:AD>0)*(AD:AD))

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!

Excel Calculation help

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.

Office Productivity

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.