No, what you want for that is in

A8: =AVERAGE(A1:A7)

then copy across to G8

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KiriumF1" wrote in message
...
Does this average the 7 rows of data? Each row has 7 columns of data, so
final output should be 1 row of 7 columns of data

"Bob Phillips" wrote:

Are you meaning

=AVERAGE(A1:G7)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KiriumF1" wrote in message
...
i have 7 rows by 7 columns of data. How to program in such a way to
output
1
row with the average of the 7 rows of data? Thanks in advance!