Hi All
I'm new to the forums so apologies if this has been covered elsewhere.
I'm trying to create a rolling average of Tenpin bowlers weekly scores with a formula that will find non-blank cells within a row and calculate the average of the last 3 non-blank entries. If there is less than 3 entries it needs to give the average of the entries it finds.
Example:
B2 C2 D2 E2 F2 G2 H2
Player A 161 210 144
Player B 145 143 144
Player A Rolling ave. = 171.67 ((161+210+144)/3)
Player B Rolling ave. = 144.00 ((145+143+144)/3)
with them adjusting for the next entry:
B2 C2 D2 E2 F2 G2 H2
Player A 161 210 144 155
Player B 145 143 144 163 159
Player A Rolling ave. = 169.6667 ((210+144+155)/3)
Player B Rolling ave. = 155.3333 ((144+163+159)/3)
If it could round the answers down that would be useful too.
Thanks in advance for your help
Bookmarks