What should happen if there aren't 5 or 10 numbers to average?

--
Biff
Microsoft Excel MVP


"kjal" wrote in message
...
Hello, I need to design a spreadsheet that averages the last 5 and last 10
numbers in a row of up to 40 numbers. There will be various random spaces
between the entered numbers. So for example, if there are 15 numbers
spread
over 40 rows, I would need to average the last 5 which could each have a
few
spaces between them. There will be no 0's or negatives in the data.

Thanks