Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to sum up fields that are not empty

Topic Labels: Formulas
Solved
Jump to Solution
406 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everybody,

I got 7 fields that are either empty OR contains a name… Is there a formula which sums up how many of these 7 fields contains a name (and aren’t empyt)?

Thanks in advance!

1 Solution

Accepted Solutions
Max_Ha
6 - Interface Innovator
6 - Interface Innovator

Got it… It was super simple:

COUNTA({field1},{field2},{field3},{field4},{field5},{field6},{field7})

See Solution in Thread

1 Reply 1
Max_Ha
6 - Interface Innovator
6 - Interface Innovator

Got it… It was super simple:

COUNTA({field1},{field2},{field3},{field4},{field5},{field6},{field7})