Category: Excel Formulas

You can count the number of cells 10 days before a date with the COUNTIF function or the SUMPRODUCT function. Example: You are working on a worksheet with the …

To count the number of cells 10 days before, you can use the COUNTIF function or the SUMPRODUCT function. You can change the 10 days into any number of …

To count the number of text cells with some characters, you can use the COUNTIF function with the wild card of the question mark (?), where the question mark …

You often will see different errors when working with a worksheet. There are seven common errors in Excel, each caused by various reasons: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, …

Spaces are important to separate words in a sentence making it easier to read. However, one space between two words will be enough and all other spaces will be …

When working with Excel, especially when you automate a report, you may need to get the group name for the minimum value. Example: You are working with the survey …