Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

COUNTIF Equivalent

1442 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_Burrus
6 - Interface Innovator
6 - Interface Innovator

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.

0 Replies 0