| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
