Average formula

  • Thread starter Thread starter Scoober
  • Start date Start date
S

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.
 
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
 
Far out Mike. I did not even know about that. Egg Face, you learn something
every day. Thankyou
 
Back
Top