| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula to average every other value in a column.
I have columns with 100+ values. I need averages of the odd numbered rows
and then averages of the even numbered rows. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to average every other value in a column.
=AVERAGE(IF(MOD(A1:A100,2),A1:A100,"")) for the odd rows
=AVERAGE(IF(MOD(A1:A100,2),"",A1:A100)) for the even rows In each case, enter as an array formula, with Control Shift Enter. -- David Biddulph "Coach J" <Coach wrote in message ... I have columns with 100+ values. I need averages of the odd numbered rows and then averages of the even numbered rows. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to average every other value in a column.
for the even rows:
=AVERAGE(IF(MOD(A1:A100,2)=0,A1:A100)) as an array formula for the odd rows: =AVERAGE(IF(MOD(A1:A100,2)=1,A1:A100)) as an array formula -- Gary''s Student - gsnu200775 "Coach J" wrote: I have columns with 100+ values. I need averages of the odd numbered rows and then averages of the even numbered rows. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to average every other value in a column.
I'd use:
Odd Rows: =AVERAGE(IF((ISNUMBER(A1:A100)*MOD(ROW(A1:A100),2) )=1,A1:A100)) Even Rows: =AVERAGE(IF((ISNUMBER(A1:A100)*MOD(ROW(A1:A100),2) )=0,A1:A100)) Both array entered. Coach J wrote: I have columns with 100+ values. I need averages of the odd numbered rows and then averages of the even numbered rows. Any ideas? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for average recorded blood pressure readings in 1 column . | Excel Worksheet Functions | |||
| Formula for average of a top 12 numbers in a column of 24 total nu | Excel Discussion (Misc queries) | |||
| Formula to take average from column range matching another | Excel Discussion (Misc queries) | |||
| moving the formula "average" over one column in a macro | Excel Worksheet Functions | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
