Tag Archive: COUNTIFS

Articles sur le thème : COUNTIFS

Function COUNTIF


A basic task with Excel is to count the number of rows for a specific criteria. The function COUNTIF do that easily 😃 Don’t use the filters Most of the Excel users, use the filter to count the rows. But this solution is really not convenient when you have to repeat this action for many …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/countif/

COUNTIFS – Count rows automatically in Excel

Avoid the filter to count rows When you want to count the number of rows corresponding to a specific criteria, many users use the tool Filter. For 1, 2 or 3 different criteria, you can work like that. But if you have to extract a lot of count of rows for many different criteria, the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/countifs-count-rows-automatically-in-excel/

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 can’t …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/keep-your-last-updated-data/

Wildcard with COUNTIFS or SUMIFS

Wildcard characters with a COUNTIFS function

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

Permanent link to this article: https://www.excel-exercise.com/wildcard-with-countifs-or-sumifs/

Most common number in my spreadsheet

Number of times the most common number is in the document

You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL

Permanent link to this article: https://www.excel-exercise.com/most-common-number-in-my-spreadsheet/