
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Solved! Go to Solution.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 10, 2020 12:51 AM
Got it… It was super simple:
COUNTA({field1},{field2},{field3},{field4},{field5},{field6},{field7})
Reply
1 Reply 1

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 10, 2020 12:51 AM
Got it… It was super simple:
COUNTA({field1},{field2},{field3},{field4},{field5},{field6},{field7})
Reply
