COUNTIF Equivalent


#1

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.