Counting instances of an incident happening
 

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

Counting instances of an incident happening
 

=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)

"SSM" wrote in message
...
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

Counting instances of an incident happening
 

Works like a charm!!! Thanks a heap!!!
SSM

"Bob Phillips" wrote in message
...
=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)

"SSM" wrote in message
...
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