Use SUMPRODUCT to find errors on your spreadsheet.

Here's the formula: =SUMPRODUCT(--iserror([range]))
A couple ways to get to know me better⤵️
Subscribe to my free email series the Financial Modeling Educator, and go in-depth on topics like this: financialmodel...
Check out my Financial Modeling Courses as featured on Wall Street Prep and the Wharton Online Private Equity Certificate Program: www.financialm...
Thanks for watching!
-Chris