Tag Archives: SUM

A trick to SUM visible columns only (without VBA)

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 , , , | 4 Comments

Sum a range of number end with “k”

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 , , , | 2 Comments

SUM vs. SUBTOTAL

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 , | 9 Comments

SUM ignoring errors in the range

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. “+”

+ – 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