I have a column which calculates the average of a range of cells (column w) I
then have the following formula =COUNTIF(W3:W500,100%) which is working
correctly however when I change this to =COUNTIF(W3:W500,95%) or
=COUNTIF(W3:W500,89%) the calculation will not work - What am I doing wrong
please??

Thanks as always