Counting instances of an incident happening

  • Thread starter Thread starter SSM
  • Start date Start date
S

SSM

My worksheet is like this:
A1 A2...
120 210 333 400 510 625 789 801 ...10000

How can I get the how many of the cells the cells have a value between 0 and
400 (in the question above 4), how many times the cells have a value between
401 and 800 (3), etc.?

Thanks in advance...

Regards,
SSM
 
=COUNTIF(A1:A100,"<=400")

=COUNTIF(A1:A100,"<=800")-COUNTIF(A1:A100,"<=400")

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Works like a charm!!! Thanks a heap!!!
SSM

Bob Phillips said:
=COUNTIF(A1:A100,"<=400")

=COUNTIF(A1:A100,"<=800")-COUNTIF(A1:A100,"<=400")

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
You must log in or register to reply here.

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

Cell Count Between Value 13
counting number of columns 1
Counting Instances 3
Number Of Cells Between Colored Cells? 1
Counting the length of a string and adding spaces... 12
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Try to built an UDF to Count until ..... 5
counting with multiple conditions 8

Back
Top