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.
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 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 […]
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
You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL
Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.