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
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
Transcript of the video:
In Excel, how can you SUM, but ignore errors? How to SUM while ignoring errors in Excel?
Errors are so annoying. They break the AutoSum.
It won't go all the way.
And then if you do try and drag all the way the errors cause the answer to be an error. Two different solutions here.
The first one only works in Microsoft 365. Inside of the sum, we're going to say IFERROR.
And then after the range. Comma, zero.
So in other words, add up everything, if you encounter an error.
Like there's three of them there, replace that error with a 0. And we get the right answer.
Now, if you're on an older version of Excel, that's not going to work.
This function AGGREGATE will work all the way back to Excel 2013.
In AGGREGATE, the first thing I have to do is specify what the calculation is.
So a 9. Comma.
And then what to ignore.
In this case, we're going to ignore the error values. That's a 6.
Comma. And then the range to add.
Close paren, press Enter and there's your answer.
I definitely like SUM with IFERROR, but if you don't have the latest Excel, check out the AGGREGATE function.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.
Errors are so annoying. They break the AutoSum.
It won't go all the way.
And then if you do try and drag all the way the errors cause the answer to be an error. Two different solutions here.
The first one only works in Microsoft 365. Inside of the sum, we're going to say IFERROR.
And then after the range. Comma, zero.
So in other words, add up everything, if you encounter an error.
Like there's three of them there, replace that error with a 0. And we get the right answer.
Now, if you're on an older version of Excel, that's not going to work.
This function AGGREGATE will work all the way back to Excel 2013.
In AGGREGATE, the first thing I have to do is specify what the calculation is.
So a 9. Comma.
And then what to ignore.
In this case, we're going to ignore the error values. That's a 6.
Comma. And then the range to add.
Close paren, press Enter and there's your answer.
I definitely like SUM with IFERROR, but if you don't have the latest Excel, check out the AGGREGATE function.
If you like these videos, please, down below, Like, Subscribe, and Ring the bell.
Feel free to post any questions or comments down in the comments below.
