Tag Archive: COUNTIF

Articles sur le thème : COUNTIF

Function COUNTIF

If you need to count the number of rows corresponding to a name or a product, there is better than to use the filter. In fact, the COUNTIF function is dedicated for this. Presentation of COUNTIF The function COUNTIF requires only two parameters the range of cells where is your data the value you search …

Continue reading »

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

Function COUNTIFS

Usefulness of the COUNTIFS function The COUNTIFS function allows you to count the number of rows corresponding to criteria. In fact, it's a bit like filtering your data and counting the rows that match your selection criteria. Except here, it's the function that returns this number for you 👍😍😎 COUNTIFS allows you to count between 1 …

Continue reading »

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

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/