Hi All,
I could really use some help with this.
=COUNTIF(J16:J575,"Late")/COUNTA(J16:J575)*100
This Formula will give me the average but it will not change as the filters are used?
I created a formula in VBA that does work and will change as the filter changes but will only work on numbers...