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!
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!
Got it… It was super simple:
COUNTA({field1},{field2},{field3},{field4},{field5},{field6},{field7})
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.