
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 10, 2020 05:30 AM
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?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 10, 2020 05:50 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 10, 2020 05:50 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 10, 2020 06:01 AM
Drrr! Of course. Many thanks. I knew it was an easy one.
