# COUNTIF AND COUNTIFS Formulas

cancel
Showing results forย
Did you mean:ย
5 - Automation Enthusiast

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?

4 - Data Explorer

Not sure that I understand the formula but this worked exactly for what I need! A COUNTIF would be easier but this is a good work around, Thank you!

4 - Data Explorer

My workaround right now is to create a field for each status I need to count then roll them up in a related table.

Example: Employee Status field is Active, Inactive, Starting, or Leaving. I create 4 hidden formula fields with If(Status=โActiveโ,1), If(Status=โInactiveโ,1), etc then I can do a Rollup field on those fields to Count(values) or Sum().

4 - Data Explorer

Need this for counting, number of outstanding actions that match a particular criteria.

5 - Automation Enthusiast

I agree with Jack_Richards, this did exactly what I needed it to do but I donโt understand the formula AT ALL! Thank you though!

6 - Interface Innovator

How could I use this faux count if to count a specific response like Completed and then convert that into a percentage of all response?

14 - Jupiter

@Jason_Friedlander
Suppose you have a table of Tasks that can have a `{Status}` = โCompleteโ.

Supposed you have a table of Projects that can have many linked Tasks.

In your Tasks table, create a formula field; letโs call it `{Complete?}`:

``````IF({Status} = "Complete", 1)
``````

In your Projects table, create a Count field, letโs call it `{Total Tasks}`, that counts the total number of linked Tasks.
In your Projects table, create a Rollup field, letโs call it `{% Complete}`, that rolls up like this:

``````Table = Tasks
Field = {Complete?}
Agg Function = SUM(values) / {Total Tasks}
``````

Format that Rollup field as a Percentage field in the โFormattingโ menu.

(Now just convert terms to whatever your schema isโฆ โTasksโ = โResponsesโ, โProjectsโ = ???)

6 - Interface Innovator

Perfect! Thank you.

So how do I wrap that to remove the NaN in fields that are missing data.

14 - Jupiter

Which field is returning the NaN? Iโm not getting any NaNโs in my implementation

6 - Interface Innovator

I get it in my % field if the count has no records completed.

14 - Jupiter

I donโt get that in mineโฆ I just get a โ0%โ value; not sure what we are doing differently from eachother

Recently Completed Ideas