Skip to main content

Summarizing data

  • April 28, 2020
  • 2 replies
  • 29 views

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

This topic has been closed for replies.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • April 28, 2020

Check if the pivot table block does what you need!


  • Author
  • New Participant
  • April 28, 2020

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