how to average this?
 

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!

how to average this?
 

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!

how to average this?
 

Hi
=AVERAGE(A1:A7)

--
Regards
Frank Kabel
Frankfurt, Germany

"KiriumF1" schrieb im Newsbeitrag
...
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!

how to average this?
 

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!

how to average this?
 

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!