Tag Archive: COUNTIFS

Articles sur le thème : COUNTIFS

Function COUNTIF

COUNTIF

A basic task with Excel is to count the number of rows for a specific criteria. Solution with the filter 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 values. The solution is to use COUNTIF …

Continue reading

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

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/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

Greater than / Less than You can create complex conditions with the COUNTIFS function. You can enhance your criteria by adding a logical operator. In other words, you can select all the rows where one criterion is greater than a value. For example, if we want to determine the number of men with incomes greater …

Continue reading

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