Spreadsheet: 272269d1382325311-calculate-average-of-last-10-cells-in-a-row-that-have-a-value-skipping-blanks-golf-handicap-for-help
Sheet: Sheet1

NAME 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 |  |  |  | 96 |  |  |  | 93 |  | 99 | 108
[NAME] 2 |  | 80 | 80 | 83 | 86 | 81 | 90 | 84 | 82 | 80 |  | 89 |  |  | 82 |  |  |  |  | 85 | 84 |  | 83 |  |  | 75 | 83 |  | 75 |  |  | 84
NAME 3 |  |  |  |  |  |  | 97 | 102 |  | 96 |  |  | 101 | 98 | 101 |  |  |  | 105 |  |  |  |  |  |  | 101 | 102 |  | 103 |  | 93
NAME 4 |  |  |  |  |  |  |  |  |  | 83 |  |  |  | 91 | 86 | 90 | 98
NAME 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 | 86 |  |  | 87 | 88 |  |  | 85 | 90 | 88 | 86 | 84
NAME 6 |  | 89 |  |  |  | 95 |  | 105 |  |  | 87 |  | 99 | 94 |  |  |  |  |  | 102 | 94 | 95 | 96 |  | 98 |  | 100 |  | 92 | 96 | 91 | 94
NAME 7 | 106 | 95 | 104 |  |  | 99 | 90 | 101 | 98 | 95 | 99 | 94 | 87 | 95 | 95 | 97 | 84 |  | 96 | 92 |  | 97 |  |  |  | 86 | 90 |  | 95 | 100 | 93 | 89
[NAME] 8 |  |  |  |  |  |  | 94 |  |  | 92 |  | 93 | 92 |  | 89 |  | 92 |  |  |  |  |  |  |  |  | 88 | 87 |  | 90 |  | 93
NAME 9 | 93 | 90 | 83 | 81 | 93 | 88 | 86 |  | 82 | 91 | 87 | 87 | 81 | 93 | 83 | 77 | 89 |  |  |  | 83 | 89 | 83 | 83 | 86 | 87 |  | 91 | 85 | 90 | 89 | 76
NAME 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106
NAME 11 | 117 | 98 | 122 |  |  | 112 |  |  | 110 | 91 | 104 | 120 | 106 | 117 |  |  | 111 | 104 | 121 |  |  |  |  | 111 | 106 | 116 | 103 | 103 | 105 | 117 | 107 | 112
NAME 12 | 85 | 87 |  | 86 | 88 | 87 | 82 | 85 | 88 | 86 |  | 88 | 83 | 84 | 81 |  | 87 | 79 | 85 | 91 | 85 | 95 | 90 | 83 | 87 | 83 | 86 | 85 | 86 | 84 | 86
NAME 13 |  |  | 89 | 83 | 85 | 86 | 83 | 82 | 89 | 84 |  | 81 | 79 | 88 | 76 | 83 | 81 |  | 80 | 87 | 78 |  | 92 |  | 88 | 83 | 81 |  | 90 |  | 81
NAME 14 |  |  |  |  | 85 |  |  |  |  |  | 89 | 85 | 79 | 88 | 84 | 80 | 81 | 80 | 83 | 82 | 78 |  | 80 | 89 | 83 | 79 | 80 |  | 76 | 86
NAME 15 | 86 | 90 |  | 90 |  |  |  | 86 |  |  | 90 | 82 |  | 97 |  |  |  |  |  |  | 85 |  | 89 | 83
[NAME] 16 | 88 | 84 | 85 | 81 | 89 | 82 | 88 | 93 | 91 | 86 | 85 | 84 | 82 | 88 | 80 | 85 | 85 | 90 |  |  | 86 |  | 83 | 87 | 90 | 88 | 86 | 86 |  | 87 | 84 | 86
[NAME] 17 | 95 | 98 |  | 91 |  | 92 | 94 | 93 |  |  | 96 | 99 | 91 |  |  |  |  | 90 |  |  | 97 | 86 |  |  |  |  |  | 94 | 88 | 86 | 88 | 87
NAME 18 |  |  |  |  |  | 81 | 83 | 84 | 82 | 76
NAME 19 |  |  |  |  |  |  |  |  |  |  |  | 92 | 83 |  | 78 |  |  | 86 |  | 87 | 86 |  | 96 | 83 | 92 | 88 | 81 | 88 | 84 |  | 87 | 81
NAME 20 |  |  |  |  |  | 96 | 95 | 104 |  |  | 100 | 99 | 94 | 100 | 98 |  |  | 95 | 103 |  |  |  |  |  |  |  | 96 |  | 101 |  | 101
NAME 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 106
NAME 22 |  |  |  |  | 84 | 88 |  |  |  | 81 |  | 85
NAME 23 |  |  | 91 | 91 | 95 | 91 | 89 |  |  | 90 | 90 | 95 | 90 | 89 | 95 | 88 | 95 | 92 | 92 | 92 |  |  |  | 88 | 85 | 96 | 92 | 90 | 87 | 93
NAME 24 |  | 85 | 88 | 86 | 81 | 87 | 84 |  | 89 | 83 | 88 | 84 | 84 | 81 | 85 | 82
NAME 25 | 83 | 83 | 85 |  | 78 |  |  | 82 | 84 | 86 | 90 | 81 | 86 | 84 | 86 |  | 84 | 78 | 82 | 89 | 82 | 89 | 83 | 82 | 86 | 85 | 83 | 86 |  | 86 | 80 | 87
NAME 26 |  |  |  |  |  |  |  |  |  |  |  |  | 87 | 82 |  |  |  |  |  |  |  |  |  |  |  | 86 |  | 83 |  | 82 | 81
NAME 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | 81 | 84 |  |  |  |  |  |  |  |  |  |  |  | 83
NAME 28 |  |  |  | 81 | 85 | 80 |  |  |  |  | 81 |  | 80 | 80 | 78 |  |  |  |  |  | 75 |  | 75 | 78 |  | 82 | 80 |  |  | 79 | 79 | 78
NAME 29 |  | 93 | 104 |  |  | 101 | 82 | 93 |  | 88 | 98 |  | 87 | 91 | 93 | 86 |  | 91 | 93 |  |  |  |  |  | 98 | 94 | 91 |  | 90 |  | 87 | 98
NAME 30 | 85 | 83 |  | 85 | 85 | 82 | 83 |  | 87 | 86 | 90 | 89 | 85 | 92 | 86 | 78 | 89 | 85 |  |  | 85 |  | 89 | 86 | 89 | 83 | 82 | 86 | 82 | 89 |  | 85
NAME 31 |  |  |  |  |  |  |  |  |  |  | 91 |  |  | 91 | 93 | 86 |  |  |  |  |  |  |  |  |  |  | 94 | 99 |  |  | 91 | 95
average |  |  | adjust the cell range this only computes up to column ZZ
NAME 1
[NAME] 2 |  |  | array formula\
NAME 3 |  |  | hit ctrl+shift then enter not just plain enter , you'll notice that the formula wil be enclosed with braces in done right { formula }
NAME 4
NAME 5
NAME 6
NAME 7
[NAME] 8
NAME 9
NAME 10
NAME 11
NAME 12
NAME 13
NAME 14
NAME 15
[NAME] 16
[NAME] 17
NAME 18
NAME 19
NAME 20
NAME 21
NAME 22
NAME 23
NAME 24
NAME 25
NAME 26
NAME 27
NAME 28
NAME 29
NAME 30
NAME 31