Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

COUNTIF AND COUNTIFS Formulas

cancel
Showing results for 
Search instead for 
Did you mean: 
Adalberto_Santo
5 - Automation Enthusiast
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?

50 Comments
Emil_Lilja
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a nested IF formula that returns several different outputs (emojis) depending on different conditions (mostly date comparisons). In a different table i want to rollup only one specific output from this formula with a COUNTIF. This COUNTIF would also later be lookuped to an additional different table. I’ve managed to do a workaround by adding an additional formula column which checks for that specific output and returns 1 or 0 which i rollup with a normal COUNT instead. It works but would be smoother and less columns with a COUNTIF that could rollup that specific output.

pwa
5 - Automation Enthusiast
5 - Automation Enthusiast

We need some formulas which can collect the aggregate value of a field to either the table or group level.

For example;

I have a field “Sale Amount”, I’d like to create another field which is “% of Total Sales”. To achieve this currently requires an absurdly tedious system of roll-ups.

With aggregate formulas this could be done with a single field.

Example:

SUM(Field, [Table/View/Group]) which would return the sum of the field for all records. The optional second parameter could restrict the set of summed records to be either the entire table regardless of view (default option), just the records in the current view, or just the records in the current group, respectively.

SUMIFS(SumField, Condition Field, Condition, [Table/View/Group]) would work the same way, but Condition Field is the name of the field which contains the value we check and Condition might be some list of operators (Equal, Not Equal, Greater Than, etc.)

Jawed_Neshat
4 - Data Explorer
4 - Data Explorer

Hi @Jeremy_Oglesby. Given that the formula is still not there, I assume COUNTIF is not yet implemented. One of the examples I would like to use COUNTIF and COUNTIFS is in my opportunity pipeline. For instance, if I want to calculate what is the conversion rate of opportunities into “Won closed”, I would use the count if and say,

(Count field “x” if the status in field “y” equals to “Won Closed”) / count the records = conversion rate [formatted as %]

Similarly, I can use the conversation rate but for a specific year. As such, I would like to be able to use the COUNTIFS and say,

(Count field “x” when the status field “y” equals to “Won Closed” and the Year is “2019”)

with countifs, you can add as many different conditions to be met before a count is triggered.

The reason why filters don’t work is that filter reduced down the records when we don’t want to filter down the records.

I hope this gives you a good understanding of the function, its application and importance to have it incorporated into Airtable.

Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

COUNTIF please. It would solve a lot of problems and spare the headaches everyone is talking about here. Simple stuff I would think and would keep the bases nice and tidy and interoperable. Thanks.

Steve_Penson
5 - Automation Enthusiast
5 - Automation Enthusiast

This functionality would be very useful.

Joe_Tischler
4 - Data Explorer
4 - Data Explorer

Pretty obvious use cases all over Airtable team… countif is a common spreadsheet function used often for simple data evaluation. You can’t claim to replace these tools if you can’t hang with the basics.

Dominik_Fischer
5 - Automation Enthusiast
5 - Automation Enthusiast

+1
It’s super annoying to have to find a workaround for this.

Jake_Spirek2
4 - Data Explorer
4 - Data Explorer

This is a huge miss. 5 years since the first post for this and still nothing? Frustrating.

Beagle_Dev
4 - Data Explorer
4 - Data Explorer

COUNTIF is certainly a must. Currently there is no way to count all the occurrences of a single value in the field B through all the values of the field A. Which is quite a frequent need.

leowoods
5 - Automation Enthusiast
5 - Automation Enthusiast

Agreed that COUNTIF would be really useful. Kindly add!