Workaround for this use of the COUNTIF function

[Simon_Warren]

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.

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

[Williams_Innova]

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

Williams Innovations

Information Ecosystem | Williams Innovations

Williams Innovations offers consulting and management services for Airtable, information and communication structures, process mapping, and content development.