Hi all,

My first post so be gentle :D

I have/ require a spreadsheet at work that is used to 'sign' people off in terms of authorties based on a set of results.

The criteria is:

- A minimum of 50 cases must be complete
- After 50 cases to 'pass' the accuracy level must be 95% of higher (realistically this could only therefore be 96, 98 or 100%)
- 4 outcomes, Pass, and three levels of fail (only pass counts)

The issue i am having is that i require a formula for arguments sake in cell A1 that is the % of passed cases in the last 50. There is my sticking point. Yes it easy to adapt a COUNTIF formula to give the last 50, but i'd rather this was an automated process once for example a result is recorded for case 51.

Is this possible? Have i explained myself well enough?

Thanking anyone who has any ideas!

James