EXCEL help-auto calculate data?

Question

I need some help with excel. I am trying to find the function where if I add a new data set into excel, it will auto calculate with the formula already provided.

So for example

               Jan        Feb       Mar      
             12          13         11
                  3            4           6
    7.5        8.5        8.5 average

So I want to be able to add the rest of the months, input the numbers and have excel auto calculate the averages with me even touching anything.

wvl · Accepted Answer

Ensure that the average line under Mar say hsa a formula to average i.e. AVERAGE(C2: C3) Replace C2:C3 with the range of numbers you want averaged. Then click on this cell. The box around the cell will have a dot in the bottom right. Move your cursor over to the dot and the cursor will change click the mouse and hold. Drag over to the right as far as you like.

Highlight the 3 cells with jan Feb March(click in Jan and move right 3 cells.) Copy right as explained above and the other months will automatically appear.

Digital Mind · Answer

Ok, I'm just gonna show you the method for one month, and then you do the same for the others.  

So make yourself an excel spreadsheet, with the JANUARY label in row 1, column 1. 

Then leave (lets say) 50 spaces to put in your data 

At the bottom of all those spaces, in the cell that you want the average to be in, you'll put  

 =sum(a2:a52)/50 

(February would  be =sum(b2:b52)/50 and so on)

That'll give you your average.  Replace the 50 with the number of lines that you left blank to put data in.

expletive_xom · Answer

its just a copy&paste

that cell that shows 7.5 has a formula in it.
- right click on the cell and copy
- highlight across (where you want the formula to be
- then paste it

then you should be able to input numbers next to the 11 and 6 and you should get the average automatically.

if that doesnt work for some odd reason.  click on that cell with the 7.5 and let me know whats in it.

EXCEL help-auto calculate data?

3 Answers