How do I average multiple rows in Excel7 ?

[Yossarian223]

How do I average multiple rows in Excel7 ?

[ajm123456789]

=average(select the rows)
ex
=average(1:1, 3:3)

[Yossarian223]

Thank you Chicago; however I'm still confused.

Say I have a column of rows in Column E and another column of rows in Column G that I want to average in Columm N?

I've selected rows and tried to go to functions, but I have not met with success.

I appreciate your post, and ask your patience as I am not particularly IT-savvy ;-)

[ajm123456789]

attach your file here. Ill have a better idea of what your looking at

[ajm123456789]

in column N, in the cell you want to put the answer in, type this
=Average(
then select whatever cells that you want to average. Then type this
)
then press Enter

[Yossarian223]

Still feeling like a knucklehead...it's not working

[ajm123456789]

attach your file

[Yossarian223]

Hello again, and thank you.

I've created a template, which I think I can cut and paste the colums into....I hope.

Excel Averaging.xlsx

[ajm123456789]

90EE5320.xlsx

lemme know if u have any questions