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?
Page 1 / 1
You’ll want to use the aggregate function…
COUNTA(values)
SUM() is meant for numeric values 
COUNTA() will count all non-empty values.
Hope this helps!
Drrr! Of course. Many thanks. I knew it was an easy one.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.