Need to count number of team entries per month

HRR

I am trying to create a graph of number of select team entries per month. I can get a total team count and a count per month, but I can seem to find the right combination to allow team by month. I have 10 different teams that I want to track.

NicoLHC

@HRR Great Question are familiar with the countifs function?

You could try this :

You need different columns with year and months

=COUNTIFS({Team Column}, "Team A",
MONTH({Date Column}), [Month Number],
YEAR({Date Column}), [Year])

HRR

The date column is created date. So, I'm not able to break out the columns to separate month and year. Unless I misunderstood. I'm trying to create a dashboard based on 3 months of data and growing.

NicoLHC

@HRR but the created date you could use use the formula to =month , = year etc. then count.