Excel 2007 help needed

View previous topic View next topic Go down

Excel 2007 help needed

Post by Julij2 on 11/7/2014, 5:03 pm

I need to create a formula that will automatically average both rows. Copy pasting the formula individually in every column is out of the question.



Thanks and +reps will be granted for help.

avatar
Julij2
Grandmaster (2000 posts)
Grandmaster (2000 posts)


Back to top Go down

Re: Excel 2007 help needed

Post by Natsu on 11/7/2014, 5:34 pm

1st enter the average formula replacing your cell id's with whatever they are on your sheet:
Spoiler:
Then highlight the cell with the formula and click on the square black dot in the bottom right corner of the cell and drag it down
Spoiler:
after that it should have automatically adjusted the formula to suit it's respective row:
Spoiler:
avatar
Natsu
Event Demon


Back to top Go down

Re: Excel 2007 help needed

Post by Julij2 on 11/7/2014, 7:06 pm

Thanks! Smile
avatar
Julij2
Grandmaster (2000 posts)
Grandmaster (2000 posts)


Back to top Go down

Re: Excel 2007 help needed

Post by Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum