Skip to main content

COUNTIF Equivalent

  • April 9, 2018
  • 0 replies
  • 9 views

Hello. I cannot find an appropriate way on the documentation. How can I get COUNTIFS to work?

For example in Excel I use this to pull the # of “UniqueText” counts from column F in Table, and ensure the column H matches Day, and column N matches Y.

=COUNTIFS('Table'!F:F,"UniqueText",'Table'!H:H,"Day",'Table'!N:N,"Y")

I thought about linking records, but, that leaves my AirTable even messier than it needs to be.

This topic has been closed for replies.