• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting the number of cells in a range where the values is [SOLVED]

jazzkid

jazzkid

Member
I need to be able to count the number of cells (all numerical value between about 1 and 25) in a range of about 290 rows where the value in the cell is less than 6.


I have had a brief look around and can't find this anywhere and need it reasonably quickly. I'm sure this is really easy - when you know how. Thanks for any assistance.


Sue
 
Hi Sue ,


Use the COUNTIF function , as follows :


=COUNTIF($H$1:$H$290,"<6")


where your data is in column H , in the range H1:H290.


Narayan
 
Thanks Narayan That worked - didn't have the right thought processes in place when I was doing it. Knew it would be really easy.


Sue
 
You must log in or register to reply here.
Back
Top