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.
[TABLE="width: 386"]
<tbody>[TR]
[TD]TCD_c_Serial
[/TD]
[TD]Average of Days Aged
[/TD]
[TD]> 7 Days
[/TD]
[/TR]
[TR]
[TD]0000310998260036
[/TD]
[TD="align: right"]1.694375
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
[TR]
[TD]00938841502705
[/TD]
[TD="align: right"]7.617731481
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
[TR]
[TD]0B71J34002023
[/TD]
[TD="align: right"]11.45951389
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
</tbody>[/TABLE]
Any ideas on what I might be doing wrong would be greatly appreciated.
D.
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.
[TABLE="width: 386"]
<tbody>[TR]
[TD]TCD_c_Serial
[/TD]
[TD]Average of Days Aged
[/TD]
[TD]> 7 Days
[/TD]
[/TR]
[TR]
[TD]0000310998260036
[/TD]
[TD="align: right"]1.694375
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
[TR]
[TD]00938841502705
[/TD]
[TD="align: right"]7.617731481
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
[TR]
[TD]0B71J34002023
[/TD]
[TD="align: right"]11.45951389
[/TD]
[TD="align: right"]14%
[/TD]
[/TR]
</tbody>[/TABLE]
Any ideas on what I might be doing wrong would be greatly appreciated.
D.