[Affiliate]
Blog Stats
- 3,029,338 hits
-
Join 3,904 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Simple Basket Analysis - Formula approach with #Excel 365
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- Rename column names in a dynamic way with #Excel #PowerQuery
- Perform VLOOKUP with 2 lookup values
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: SUM
How to sum a range with #ERRORS in #Excel?
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
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
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
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
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
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