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.
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 are the formulas ?
=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")
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...