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

How to make automatic calendar in Excel

Creating a new calendar each month is a waste of time, but many people do as they think they need to rebuild it to get correct weekends and public holidays. But in fact, with few formulas, 2 conditional formatting rules, 1 dropdown list and 5 lines of VBA code, you can create an automatic calendar. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/how-to-make-automatic-calendar-in-excel/

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/