This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
It would be great if the COUNTIF and the COUNTIFS formulas were implemented in Airtable. I use them in most of my excel spreadsheets, and it is a little frustrating not being able to use it here. Are there any plans to add more formulas?
I am trying to count all instances across multiple columns for a specific record for a certain word. I do this in excel quite easily with COUNTIF. I will have to scrap using this product for this reason.
any new here? its been 5 years bout window count if not even available for airtable whats happening?
Would love CountIf… any update???
Read all the comments here in such high hopes for an update at the bottom…and nothing :grinning_face_with_sweat:
Another request for COUNTIF please! We are using Airtable across several organizations to track the progress of a project, completing a survey of historic dance halls in Texas. Every quarter, I need to report the total number of halls that meet each of 7 status conditions. A COUNTIF formula would make this easy – instead, I guess I have to download the spreadsheet out of Airtable to run the calculation every time. Kind of ridiculous when you consider how basic a formula COUNTIF is.
Just signed up to a trial of Airtable to find this thread. I need this simple formula =COUNTIF($H$2:$H,G2) to count how many instances of an affiliate referral code has been used. strange that it’s not possible. But maybe I don’t know how to use the platform properly yet.
I really need to COUNT with different date options. I think COUNTIF should help me. Please add it to Airtable, guys!
Hello! We are working on an extension that will allow you to add COUNTIF & COUNTIFS and other criteria formulas (eg. SUMIF) to Airtable. Our solution is no-code and will take to minutes add to your tables:
Feel free to join our waitlist or send any feedback or questions to email@example.com .
The best way to get this working natively that I’ve found is to use regex. For example, trying to count all occurrences of Active. It requires , and 1 to not be a part of the text. I only tested this with a Rollup.
Formatted to read it easier:
ARRAYCOMPACT - remove empty string and null from values
ARRAYJOIN - join rest of values with comma to have a deliminator
REGEX_REPLACE 2 - replace all occurrences of Active followed by a comma or end of string with 1 followed by a comma or end of string
REGEX_REPLACE 1 - replace anything that isn’t a 1
LEN - return length of string, which is the count of 1s
If REGEX_REPLACE supported it, ideally Active(,|$) would be (?<=^|,)Active(,|$) to enforce the presence of the deliminator or start of string.
A native COUNTIF would be great still.