Ok fellas...many thanks for all the quick responses

Looking at them, I'm starting to feel a right Thicko

I've managed to sort out the HTML maker (eventually) so a snapshot of my chart should appear below.

A quick word of explanation might help so here goes...........

1. Pages are in landscape format and are printed out so that they can be pinned on the notice board.

2. Once a competitor has shot his round, he will estimate his own score before sending the target card away for verification. He pens in this score in the top left box of this scoresheet (cells D7, F7, H7, J7, etc in this example). Note that scores are calculated on the basis of points dropped out of 100 rather than actual points scored.

3. Once the score has been verified (anything up to 2 weeks later), it's entered into the lower right box of the scoresheet ( cells E8, G8, I8, K8, etc)

4. In order to get a running average of the scores, I've used the following formulae and set-up:

in cell G7

*=100-AVERAGE(E8,G8)* then cell F8=G7

in cell I7

*=100-AVERAGE(E8,G8,I8)* then cell H8=I7

in cell K7

*=100-AVERAGE(E8,G8,I8,K8)* then cell J8=K7

in cell M7

*=100-AVERAGE(E8,G8,I8,K8,M8)* then cell L8=M7

Now the formula starts to 'roll' along

in cell O7

*=100-AVERAGE(G8,I8,K8,M8,O8)* then cell N8=O7

in cell Q7

*=100-AVERAGE(I8,K8,M8,O8,Q8)* then cell P8=Q7

and so on through to the last round.

In the Average cells at the end of the sheet (Z7 ?), I've used the following:

=IF(Y8>0,X8,IF(W8>0,V8,IF(U8>0,T8,IF(S8>0,R8,IF(Q8>0,P8,IF(O8>0,N8,IF(M8>0L8)))))))

This gives me a constantly updated average of the scores (or seems to :wink: ) every time the sheet is amended.

Now to the problem.............(bet you thought I'd never get round to it did you?

)

The average at the end of the sheet gives me a 'Total' average of the competitors last 5 rounds.

What I really need is the average of the best 5 out of the last 6 rounds.

Hope this makes things clear and I haven't confused the hell out of everyone.

Iain