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.

Re: Formula to sum up fields that are not empty

Solved
Jump to Solution
1083 0
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