Calculating an average in a single cell

[martynmordecai]

Hey,

I want to have one single cell that when i add figures to it, they automatically give me a running average.

Like this thread, but instead of adding the numbers together it will add the numbers together and divide by how many times i have entered a number
http://www.excelforum.com/excel-new-...that-cell.html

Get me?

Thanks

[FDibbins]

This cannot be done with a regular excel formula, and the link you posted used VBA for what the OP wanted. I will move this thread to the VBA forum, you will get better help there

[Mallycat]

This is a non trivial problem the way you have described it, much harder than the sum example you posted. The key issue is that you need to keep track of 2 sets of data. The current total (as per the sum example) but also the total number of numbers ever entered. What happens if you enter the number 2, 4 times. The average will be 2. So how will you know if it worked or not? What happens if think it didn't work, and you do it again. Now you have 5 times 2 and no way to undo what you did.

Why do you want to do it this way? What is the actual problem you are trying to solve? Why can't you create a table that allows you to add new numbers to the table, have a running total and average. That way you can keep records of all the numbers you have entered in the past.

[martynmordecai]

the reason i want this is because of space.
i have allot of data and i dont want extra cells cluttering up the spreadsheet and making it look confusing

[watersev]

hi martynmordecai, please check attachment, input numbers in C3 (numbers only allowed) to get running average

[martynmordecai]

it dosen't seem to be doing anything

[watersev]

if you enter the following numbers in C3, for example: 1 then 2 then 3 then 4
you will get C3 value: 1 then 1,5 then 2 then 2,5
Do I get something wrong on your issue?

[FDibbins]

When I tried your file, it worked for me too, waterserv

[martynmordecai]

ive tried many times are it wont work for me. the number in cel c3 just stays the same

[watersev]

try to run the following first:

Please Login or Register  to view this content.

and then try to input numbers in C3