Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Simple roll-up not working

Topic Labels: Formulas
Solved
Jump to Solution
352 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

Screenshot 2020-07-10 at 13.28.07

1 Solution

Accepted Solutions

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!

See Solution in Thread

2 Replies 2

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!

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