Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

14 points

what function do i enter to get a count of cells that ≥ $20.25

I am trying to get a count of cells in a column that are ≥ $20.25. I tried using countifs but that does not work.

Numbers 3.6.1

Mac Pro (early 2009)

Version 10.11.1

2.93 GHZ

8 GB memory

thanks

Posted on Nov 22, 2015 4:28 PM

Reply

Best reply

Level 8

35,336 points

Posted on Nov 22, 2015 4:34 PM

You can try this:

=COUNTIF(A,">=20.25")

Note the use of the "

SG

View in context

1 reply

Best reply

Level 8

35,336 points

Nov 22, 2015 4:34 PM in response to jms54

You can try this:

=COUNTIF(A,">=20.25")

Note the use of the "

SG

Reply

what function do i enter to get a count of cells that ≥ $20.25

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up