Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: COUNTIF Function across Row Data

6316 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon_Warren
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Williams_Innova
7 - App Architect
7 - App Architect

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