Count with Blanks

[d3stijl]

I have a list of of numbers shown as percentages in A1:A25 within the list there are some blank cells.

I need to count the amount of numbers that are >= 7.50% but the blank cells seem to be counted as zeros and are causing problems.

Anyone help me out with the countif statement that will ignore any blanks?

 

[yesterdays]

What is the formula you're using?

 

[steve the fish]

This ok?

=COUNTIF(A1:A25,">=0.075")

 

[d3stijl]

I've worked it out.... I've copied the %'s into another column and changed the formatting to decimals. I've hidden the decimals to neaten it up and voila.

=COUNTIF(A1:A25,">=0.0500")

My percentages go to 2 decimal points so I've had to make the decimals go to 4 decimal points.

A bit scrappy but it works.

 

[d3stijl]

Sorry I didn't see your post but that's the method I've went with....Thanks for getting in touch....I just thought there might of been a formula I could use to avoid doing all the extra leg work

Thanks again.

 

[steve the fish]

Formatting makes no difference to a cell value. 0.05 is equal to 5%?

 

[d3stijl]

I see what you mean (duh)....Thanks again.