Hello
would someone be kind enough to help me with this average question.
The formula belwo works perfectly but I would like to change it so that it will average if there is only 1 or up to 15 numbers. At present it will only average and work if there are 4 or more numbers

=AVERAGE(SMALL(IF('previous race results'!$A$1:$A$861=B36,'previous race
results'!$B$1:$B$861),{1,2,3,4}))

regards
Ditchy