Excel 2007 help needed

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.

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:

Thanks!