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 are the formulas ?





To count in the previous month:


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:


To count in the current month:


To count in the next month:


Interesting Management