Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

COUNTIF Function across Row Data

Topic Labels: Views
2022 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, How can i count for a condition, i,e, COUNTIF for entries in fields of the same record, i.e looking at ROW Data, e.g.
image

I want to count how many persons are Competent, which in this example is 2, but i could only get COUNTA to work, and that just looks at “is field empty or not”.

Cheers, Si

1 Reply 1

Hi @Simon_Warren,

A couple of things first. I think this post would generate more feedback and faster responses in the Formulas section of the forum. Lastly, you may benefit from rethinking your base layout, where you split the data across 2 or more tables (Skills in one table, people in another). This will allow you a lot more flexibility in the long run and be much easier to manage.

Now, to your original question. Airtable doesn’t currently support a “COUNTIF” formula. You really have 3 options, and it seems you’ve found one that works, to a degree. I would suggest using a formula field and combining an IF statement (to return a flag like 1 or 0) and either a SUM or COUNT from there. You may even use a ROLLUP field if you split between 2 tables.

Hope this helps.

Thanks
Chris