Numbers (macOS) counting

numbers
#1

I’m wondering if any one here would know if it’s even possible to do this:

In Numbers, I have a list of distances (kilometres walked) and what I would like to do is have Numbers count the number of times the value is X, Y, or Z and indicate it in different cells.

In the attached image, for example there are 10 over 21.1km, 2 under 15km, and 5 between 15 and 21.1km.

Any suggestions?

03%20AM
Screen Shot 2019-03-14 at 1.11.03 AM.png234×557 41.2 KB

#2

You should be able to do it with COUNTIF and COUNTIFS. E.g., COUNTIF(B2:B12,”<15”) or COUNTIFS(B2:B12,”>=15”,B2:B12,”<21.1”), etc.

#3

Thanks! I’ll give that a whirl.