Count data for a specific value in a month with a formula in an excel report

This formula allows me to know how many times a particular value appears during a month, it can be during the previous month, 3 months ago, current month, next month, etc.

formula excel

 

When I use the formula ?

Each time that I need to know how much the specific value exists in a month.

 

How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".

 

How is/are the formula(s) ?

=COUNTIFS()

=EOMONTH()

=TODAY()

=INDIRECT()

To count in the previous month:

=COUNTIFS(C:C,">="&EOMONTH(TODAY(),-2)+1,C:C,"<"&EOMONTH(TODAY(),-1)+1,INDIRECT("A:A"),"chocolate")

The column C is where is the date and the column A is where “chocolate” can be found. If the word is in a cell, put the cell reference in the formula:

=COUNTIFS(C:C,">="&EOMONTH(TODAY(),-2)+1,C:C,"<"&EOMONTH(TODAY(),-1)+1,INDIRECT("A:A"),E7)

To count in the current month:

=COUNTIFS(C:C,">="&EOMONTH(TODAY(),-1)+1,C:C,"<"&EOMONTH(TODAY(),0)+1,INDIRECT("A:A"),"chocolate")

To count in the next month:

=COUNTIFS(C:C,">="&EOMONTH(TODAY(),0)+1,C:C,"<"&EOMONTH(TODAY(),1)+1,INDIRECT("A:A"),"chocolate")

Interesting Topics