Average formula

[Scoober]

I am looking for a formula that will average a row of cells.

The problem I am facing is that all the cells that require averaging may at
different times have a different amounts of lines in the equation.

i.e

A1 6.5%
A2 6.5%
A3 6.5%
A4 6.5%
A5 6.5%

Using =sum(A1:A5)/5 gives me the answar 6.5% with is correct. But if I only
have 4 figures in my row the formula falls over

i.e.

A1 6.5%
A2 6.5%
A3 6.5%
A4 6.5%
A5

The original formula will give the average answer as 5.2% which is clearly
incorrect as the average is still 6.5%.

Can any body help with oine formula that will work correctly regardless of
how many lines are in the equation.

Thank you in advance.

 

[Mike H]

Hi,

I may be missing something here but why aren't you using AVERAGE which will
ignore blank cells

=AVERAGE(A1:A5)

So if A5 is empty it is ignored

Mike

 

[Scoober]

Far out Mike. I did not even know about that. Egg Face, you learn something
every day. Thankyou