Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to sum up fields that are not empty

Topic Labels: Formulas
Solved
Jump to Solution
1399 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Max_Ha
6 - Interface Innovator
6 - Interface Innovator

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})