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!