Skip to main content
Solved

Formula to sum up fields that are not empty

  • November 9, 2020
  • 1 reply
  • 34 views
M
Forum|alt.badge.img+2

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!

Best answer by Max_Ha

Got it… It was super simple:

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

1 reply

M
Forum|alt.badge.img+2
  • Max_Ha
  • Author
  • Inspiring
  • Answer
  • November 10, 2020

Got it… It was super simple:

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

H
Terms & ConditionsAccessibility statement