Help

Re: Summarizing data

371 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kal_el
4 - Data Explorer
4 - Data Explorer

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

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

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

2 Replies 2

Check if the pivot table block does what you need!

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