Formula for automatically adding rows to range

Hi

I have a range of data from C3 to C292 and I want to find the average of this data. I also want the average to update when new data is added to the rows below.

Eg

Date... Value
1/1/13...10
2/1/13...14
3/1/13...12
4/1/13....15

Average =

Then when data for the 5th, 6th and onwards are added, I want the average to change.

What is the formula?

Thanks,

Have you tried:

=AVERAGE(C:C)

Originally Posted by Andrew-R

Have you tried:

=AVERAGE(C:C)

Yeah I have, that just produces an average of 0... It's because I have headings in C1 and C2 which mucks up simply doing it =Average(C:C)

How do I get it just to go from cell C3 where the data starts down to the last cell of filled data in column C?

Thanks,

Still the same problem for me

Maybe it's a difference between Excel 2007 and 2010. Anyway, my formula from the post above should work.

It worked for you because you included numbers after each of the headings which was counted into the average. If you get red of them then you have the same problem I'm getting. And I'm on Excel 2013 at work at the moment.

The rough sheet I was using just used "Test" (with no numerics) as the headings and the formula still worked fine, and deleting the numerics from the headings in the example sheet I posted doesn't stop it working.

Strange.

Anyway - the formula I posted in post #4 will work whatever.

The formula didn't work either, it still produces 0

Then we have another problem. Can you post an example workbook?

Here's a modified version of it. It's slightly different but the same problem still appears.

How do you reckon I could solve it so the more lines added at the bottom will be added to the average total?

Thanks,

Both the straightforward =AVERAGE(B:B) and the more complex formula work fine if you don't put them in column B!

If you do then you're trying to have the average include the average itself, which obviously causes problems.

If what you're after is to be able to enter more rows of data and then have an average appear at the bottom then you need a macro, not a formula.