Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel How To Sum But Ignore Errors – 2576

Posted on by Annie D

You have a range of numbers in Excel but there are some error cells. When you try to use AutoSum, it selects the wrong range. When you select the correct range, the Sum is replaced by an error.
This video shows two methods for solving the problem:
With Microsoft 365, add IFERROR inside the SUM.
With older Excel, use the AGGREGATE function to ignore errors.

This video answers these common search terms:
How to get excel to ignore error in sum.
How to ignore errors when summing in Excel.
How to sum columns in Excel with “#value!”.
How to sum columns in Excel with # value.
How to sum excel ignoring n/a.
How to sum in excel excluding.
How to sum in excel with #n/a.

Table of Contents
(0:00) AutoSum with Error cells
(0:18) Add IFERROR inside of SUM
(0:46) Use AGGREGATE to ignore errors
(1:13) Wrap-u

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comMon, March 27, 2023 7:44am