Count events in a period

[Christian_Zenge]

Hi

I would like to count the number of events within a period. The setup is as follows:

• Table “Matches” with fields “team (referenced to “Teams” table)”, “kickoff (date day&time)”

• Table “Teams” --> new formula field to count number of matches in a specific season/period on “Matches”

Is it possible to create such a formula without the COUNTIF function?

Thanks in advance for your support, Chris

[Ilan_Ben_Yaakov]

hi Chris,
I would create the time periods on “matches” like this:

IF(AND(kickoff>="2018-07-01",kickoff<="2018-07-31"), kickoff)

and then, on Teams, I will use rollup field with COUNTA formula to count them.
something like this base
https://airtable.com/shr1tXBmNYuNmQrr7

[Christian_Zenge]

hi Ilan, that’s a great idea, works perfectly… …until COUNTIF is available.

Thanks :grinning_face_with_big_eyes: