Hi!

What is a 3 point moving average?

Does that mean you want to average the last 3 values in a
row?

Try this entered as an array with the key combo of
CTRL,SHIFT,ENTER:

=AVERAGE(IV1:INDEX(1:1,LARGE(IF(1:1<"",COLUMN(1:1 )),3)))

This will average the last 3 numeric values entered in row
1, A1:IV1.

Biff

-----Original Message-----
I would like to enter a formula for a 3 point moving
average on a spreadsheet
that ignors blank cells in the row. Is there a function
or combination of
functions that will do this? Or must it be done using a
macro, and if so how?
On charts you can add a moving average and even
projections, but I can't
find a function that does the same on a spreadsheet. Can
anyone assist??

Thanks
.