How to Sum the Smallest N Values in Excel
March 22, 2022
Summing is one of the most powerful use of Excel. However, SUM function doesn’t perform all the summing the way we want. For example, when we want to sum the bottom n values in Excel. You can sum those values by using + but it can cost you a few hours if you have a long list to add up.
How to Count Cells that do not Contain Errors in Excel
December 7, 2020
Background Sometimes you may want to know the number of cells does not contain errors in your workbook. Indeed this it not difficult at all. You can accomplish it with just one simple formula. In this article, I will show
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)
