Re: Formula to sum up fields that are not empty

Max_Ha · ‎Nov 09, 2020

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 · ‎Nov 10, 2020

Got it… It was super simple:

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

See Solution in Thread

Max_Ha · ‎Nov 10, 2020

Got it… It was super simple:

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

Re: Formula to sum up fields that are not empty

If Empty, If Not Empty Formula

Best formula field AI prompt

Lookup or Formula Field in a Form

Email Field Empty from Form Submission

Using IF formula to check empty cells