Countif Formula doesn't appear to working properly

[Damian37]

Hello all,
I'm trying to use a countif formula to identify when something is > 7 days, however the same results are coming up whether the object is > 7 days or not. The formula that I'm using is:
=countif(B4:B1104, ">7")/count(B4:B1104)

Ex.

TCD_c_Serial	Average of Days Aged	> 7 Days
0000310998260036	1.694375	14%
00938841502705	7.617731481	14%
0B71J34002023	11.45951389	14%

<tbody>
</tbody>

Any ideas on what I might be doing wrong would be greatly appreciated.
D.

 

[Joe4]

Based on your example, your formula returns 0.66667, which is correct, as 2 out of the 3 records exceed 7.
What does your formula return on those three records?

 

[cerfani]

Your formula would just tell you what % of rows have values greater than 7 in column B (ignores blanks)

what else should it do? not sure what you mean to do... are you trying to calculate something on each row and drag down?

this will tell you if a row is greater than 7... =B4>7 then you get true and false... that would do what you said... identify which rows are greater than 7... you need to explain a little more

 

[Damian37]

Your formula would just tell you what % of rows have values greater than 7 in column B (ignores blanks)

what else should it do? not sure what you mean to do... are you trying to calculate something on each row and drag down?

this will tell you if a row is greater than 7... =B4>7 then you get true and false... that would do what you said... identify which rows are greater than 7... you need to explain a little more

Thank you cerfani. After going over the data with my manager, just the % of instances where the data was > 7 days was what they were looking for.

D.

 

[Joe4]

Thank you cerfani. After going over the data with my manager, just the % of instances where the data was > 7 days was what they were looking for.

That is what your formula currently does. So what exactly seems to be the issue?
If there is still an issue, please explain it in detail and answer the question I posted in my earlier response.