Help

Simple roll-up not working

Topic Labels: Formulas
Solved
Jump to Solution
989 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Oliver_Weedon
6 - Interface Innovator
6 - Interface Innovator

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
AlliAlosa
10 - Mercury
10 - Mercury

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
AlliAlosa
10 - Mercury
10 - Mercury

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!

Oliver_Weedon
6 - Interface Innovator
6 - Interface Innovator

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