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
1401 1
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Max_Ha
6 - Interface Innovator
6 - Interface Innovator
See Solution in Thread

‎Nov 09, 2020 10:09 AM

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!

0 Kudos
Reply
1 Solution

Accepted Solutions
Max_Ha
6 - Interface Innovator
6 - Interface Innovator
Solved See Solution in Thread

‎Nov 10, 2020 12:51 AM

Got it… It was super simple:

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

See Solution in Thread

Reply
1 Reply 1
Max_Ha
6 - Interface Innovator
6 - Interface Innovator
Solved See Solution in Thread

‎Nov 10, 2020 12:51 AM

Got it… It was super simple:

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

Reply
Copyright © 2025 Khoros, LLC
Top