Tag Archives: AGGREGATE

How to sum a range with #ERRORS in #Excel?

Posted on June 11, 2022 by MF

SUM is probably the most frequently used function in Excel. And probably the first function we learned. Though powerful, it cannot handle errors… 😰 This is the fact we need to deal with. SUM cannot handle errors. AGGREGATE comes to … Continue reading →

Rate this:

Posted in Formula | Tagged , | Leave a comment

SUM ignoring errors in the range

Posted on March 22, 2014 by MF

Different ways in getting sum of a range with “Error” Thanks to the comments made by a friend, I would like to share a few workarounds to ignore errors with SUM. 1) Use a helper column This would be an … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment