Formula to sum up fields that are not empty

[Max_Ha]

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!

[Max_Ha · Accepted solution]

Got it… It was super simple:

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