Average Row Formula

Is there a way to calculate the average of a row if some cells are
empty but when calculating the average they should have the value of
the cell to the left?

If the following data is enterered

A B C D E F G

1 3 5 6

For the calculation the cells should use the data

A B C D E F G

1 3 3 3 5 5 6

Also what would the average formula be if you wanted to skip one of the
cells from the average calculation?

Thanks

Tom

pls do NOT multipost. It wastes resources

--
Don Guillett
SalesAid Software
donaldb@281.com
"Tom" <tsanders123@hotmail.com> wrote in message
news:1115469850.440080.158390@g14g2000cwa.googlegroups.com...
> Is there a way to calculate the average of a row if some cells are
> empty but when calculating the average they should have the value of
> the cell to the left?
>
> If the following data is enterered
>
> A B C D E F G
>
> 1 3 5 6
>
> For the calculation the cells should use the data
>
> A B C D E F G
>
> 1 3 3 3 5 5 6
>
> Also what would the average formula be if you wanted to skip one of the
> cells from the average calculation?
>
> Thanks
>
> Tom
>

Answered in microsoft.public.excel

Jerry

Tom wrote:

> Is there a way to calculate the average of a row if some cells are
> empty but when calculating the average they should have the value of
> the cell to the left?
>
> If the following data is enterered
>
> A B C D E F G
>
> 1 3 5 6
>
> For the calculation the cells should use the data
>
> A B C D E F G
>
> 1 3 3 3 5 5 6
>
> Also what would the average formula be if you wanted to skip one of the
> cells from the average calculation?
>
> Thanks
>
> Tom