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: https://financialmodelingeducator.com/

Check out my Financial Modeling Courses as featured on Wall Street Prep and the Wharton Online Private Equity Certificate Program: https://www.financialmodelingeducation.com/

Thanks for watching!
—Chris

Скачать видео