Forum Discussion

Jade Fertig's avatar
Jade Fertig
Copper Contributor
Jun 17, 2018

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 =AVERAGE(C3:Z3) and so on, what i would like to do is select all of row B 2-1000 at once and put one formula instead of going to each line. I have 450 lines per spread sheet that I have to make is there a formula that with allow me to do so?

Formulas & Functions
tips and tricks

2 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jun 17, 2018

    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

    • Arul Tresoldi's avatar
      Arul Tresoldi
      Iron Contributor
      Jun 17, 2018

      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.

Resources