Count or CountA

A

Arturo

One column of numbers from A1:A10
Trying to count how many of the numbers are > 60
=COUNT(A1:A10>60) aint working...

Appreciatively,
Arturo
 
B

Bob Phillips

=COUNTIF(A1:A10,">60")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 3
How to count the numbers in a Word document? 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Section and Page numbering 0
Countif function for Even and Odd numbers 34
COUNTA Function 7
count - but exclude counting cells with a formula 4
Logical formatting for multiple values 1

Top