Blog Stats
- 2,374,282 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Open an embedded Excel file during a slide show in PowerPoint?
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: SUMIF
The power of Dynamic Arrays in #Excel 365
… in creating dynamic drop-down with conditions Making a dynamic drop-down list is not difficult. It may require multiple steps, helper formula and/or helper tables though. And the number of helper tables depends on the complexity of the requirement. I … Continue reading
Posted in Excel in Action, Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, SORTBY, SUMIF
Leave a comment
15-significant-digit issue with SUMIF(S), COUNTIF(S), AVERAGEIF(S)
Have you applied SUMIF or COUNTIF to a range that contains numbers with more than 15 digits stored as text? If you did or if you do, you’d better continue to read this as you’ve got wrong answers that you … Continue reading
2D SUMIF with two variables – one on column and one on row
SUMIF is a commonly used function to give you sum of a range that meets a specific criterion. For the example above, if you want to know the total expense of Department 1 in Jan, you can use SUMIF: The Syntax … 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