Solved

Simple roll-up not working

+6

I want to count the number of attendees on course. I’ve uplodad a pic of the formula. Any ideas what I’ve done wrong?

Best answer by AlliAlosa

You’ll want to use the aggregate function…

COUNTA(values)

SUM() is meant for numeric values :slightly_smiling_face: COUNTA() will count all non-empty values.

Hope this helps!

+19

You’ll want to use the aggregate function…

COUNTA(values)

SUM() is meant for numeric values :slightly_smiling_face: COUNTA() will count all non-empty values.

Hope this helps!

+6

Drrr! Of course. Many thanks. I knew it was an easy one.

Sign up