Tag Archives: SUM

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

A trick to SUM visible columns only (without VBA)

Posted on August 29, 2015 by MF

We know that SUBTOTAL allows us to perform some basics functions like SUM, COUNT, AVERAGE, etc.  that apply to visible rows only.  However, there is no similar function for visible columns only. If we need to SUM visible columns only, we will need … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 14 Comments

Sum a range of number end with “k”

Posted on April 11, 2015 by MF

Does it sound familiar to you? If you are having this kind of issue all the time, you may want to continue reading this as I am going to show you three different approaches to fix the problem. Non-Formula approach Formula … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments

SUM vs. SUBTOTAL

Posted on March 26, 2014 by MF

How to SUM a range but ignores SUM result in between?, i.e. How to get a Grand Total with SubTotals in between? How to SUM but ignores hidden cells or filtered cells? SUM could be the most popular function used in … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | 11 Comments

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

Excel Basic – Sum vs. “+”

Posted on March 18, 2014 by MF

+ – x / would be the four basic operators you learned in Excel basic.  When you learned to use SUM instead of +, did you ask yourself or your teacher why? 1) SUM is much easier to input and … Continue reading →

Rate this:

Posted in Excel Basic, Formula | Tagged | 9 Comments