I want to count how many tickets the Assigned to group Business Systems received in January

Louis.Smith

I am trying to count the amount of tickets the Business Systems teams received in January. There are other teams in other rows.

The formula I tried was:

=COUNTIFS([Assigned Team]:[Assigned Team], @cell = "Business Systems"), @cell <= TODAY(), [Assigned Team]:[Assigned Team], @cell > TODAY(-30))

heyjay

=COUNTIFS(
[Assigned Team]:[Assigned Team],"Business Systems",
[Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = 1)

Where 1 represents the month in sequence.