Summarizing data

[Kal_el]

I’m trying to summarize date data from 3 different columns:

I want to summarize it based on the month of the year so it will look like this:

When I was using Google sheets I would have simply used the “countifs” formula and that counted dates based on the month & year formulas

Since there is no countifs in Airtable I can’t figure it out either via a formula or either via pivot table

[ScottWorld]

Check if the pivot table block does what you need!

[Kal_el]

Pivot table block can’t be used for more than one column, I have 3 columns