COUNTIF AND COUNTIFS Formulas

[Adalberto_Santo]

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?

[Emily_Purser]

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.

[Chadd_Dumagas]

any new here? its been 5 years bout window count if not even available for airtable whats happening?

[Michael_Townsen]

Would love CountIf… any update???

[Edan_Ben-Atar]

Read all the comments here in such high hopes for an update at the bottom…and nothing :grinning_face_with_sweat:

[Maciej_Smola1]

• 1 from me, would you to track [Person][Date][Changed status] in a given month

[Steph_McDougal]

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.

[Rob_Tucker]

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.

[Petr_Serdyukov]

I really need to COUNT with different date options. I think COUNTIF should help me. Please add it to Airtable, guys!

[supersparks]

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:

supersparks.io

Airtable Sumif, Countif, and Averageif formulas - Supersparks

Use criteria range formulas in Airtable like you would in Google Sheets or Excel.

Feel free to join our waitlist or send any feedback or questions to hello@supersparks.io .

[Trevor_Dearham]

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:

LEN(
    REGEX_REPLACE(
        REGEX_REPLACE(
            ARRAYJOIN(
                ARRAYCOMPACT(values)
            , ',')
        ,'Active(,|$)','1$1')
    ,'[^1]','')
)

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.