Forum Discussion
need help with a formula on Excel
I'm trying to create a formula on excel on B2 through B1000 that takes the average of each individual row starting on row 2 so for the first row in B2 it would be =AVERAGE(C2:Z2) . Then B3 would be =...
Hi Jade,
I can imagine that the data in your spreadsheet looks like this:
So, you can put this formula into cell B2:
=AVERAGE(C2:Z2)
And then copy it down using the Fill Handle.
Regards
Or you can copy che first cell, then with the arrows of the keybord you go right (to the column with data); then click ctrl+down_arrow and you should arrive at the last data. Then back to the left (in the now empty column in which you want the average); ctrl + shift + up_arrow and ctrl+v to paste that formula in all the selected cells.