Function COUNTIF in Excel
The COUNTIF function of Excel returns the number of rows within a range according to a criterion. Learn how to use it in this article.
COUNTIFS
COUNTIFS – Count rows automatically in Excel
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
Keep your Last Updated Data
Keep the last updated row Let's start from a file storing customer information. Some customers have multiple records in the file, as a new record was created each time they changed their address or phone number. How do you keep only the last updated row? 🤔🤨 Remove duplicates not applicable With a such file, you […]
Wildcard with COUNTIFS or SUMIFS
You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.The wildcards are specials characters to replace one or more characters in your string
What is the Most Common Value in your Excel document.
You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL
TOP 10 Most Useful Statistics Excel Functions for Data Analysis
Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.