Tag Archive: COUNTIF

Articles sur le thème : COUNTIF

Function COUNTIF

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

The COUNTIFS function returns the number of rows you have in a worksheet based on one or more criteria. It’s like filtering your data

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

Change the color of the weekends

The weekends have a different color automatically

Dates play a big role in many workbooks. With the tool conditional formatting you can create rules to highlight critical dates easily

Permanent link to this article: https://www.excel-exercise.com/change-the-color-of-the-weekends/