Count If cell is less than a certain number?

[controlfreak]

Hi Folks,

I have a sheet here which shows how long in days certain items are open which I have contained in the W column. Some less than 30 days, some more.
What I want to do is for Excel to count the number of cells that are less than 30 and count the amount that are more.
Then I can view the 2 numbers as a percentage of the total.
This is probably an easy task but I can seem to get it to work.

Thanking you!

[benishiryo]

hi there. you forgot to attach the file. here's how to count less than 30:
=COUNTIF(W2:W100,"<30")

to count equals or more than 30,
=COUNTIF(W2:W100,">=30")

to count total filled cells with numbers:
=COUNT(W2:W100)

divide either of the first 2 formulas with the last to get your percentage

[controlfreak]

Thanks! That got it sorted!!