Hi, I calculate “Averages” on user’s Form data; these data won’t sync in G-Sheet, so I use the dataeditor with a Maths formula: (col A + col B + col C) / 3.

Nevertheless, in the Form, the user may not fill-in all columns (for UX matters, I don’t want to make them “required”); when some cells in columns are empty, I therefore may have false “Averages” given that I always divide by “3”.

While easy in G-Sheet, how to manage the dataeditor to get: “If 1/3 column is empty, divide by 2 | if 2/3 columns are empty divide by 1”?

Many thanks in advance