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,378 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,378 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