How to take average of every twelfth cell in a column
 

Hi,

I am struggling to figure out how to take average of every twelfth cell in a
column containing a very
list of numbers.

Can anyone help me?

How to take average of every twelfth cell in a column
 

One thing you can do is write out an AVERAGE function and inside the
paranthesis you would have to select your desired cells by holding down the
Ctrl button...

now, depending on the other data on that wrksht, you may be able to write an
IF function that will average out the correct functions... but this would be
impossible for me to know how you would construct this without seeing the
data...

"uiowa" wrote:

Hi,

I am struggling to figure out how to take average of every twelfth cell in a
column containing a very
list of numbers.

Can anyone help me?

How to take average of every twelfth cell in a column
 

How about telling us what the first few cell addresses are so we can see the
pattern.

--
Biff
Microsoft Excel MVP


"uiowa" wrote in message
...
Hi,

I am struggling to figure out how to take average of every twelfth cell in
a
column containing a very
list of numbers.

Can anyone help me?

How to take average of every twelfth cell in a column
 

If F4 contains the value "12" then you can use this Array formula:

=(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*(A1:A40))))/(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*1)))


Array formulas are entered by typing the formula and instead of hitting
"Enter" key - hit "CTRL + SHIFT + ENTER" simultaneously. You can learn about
array formulas he

http://www.cpearson.com/excel/ArrayFormulas.aspx



"uiowa" wrote:

Hi,

I am struggling to figure out how to take average of every twelfth cell in a
column containing a very
list of numbers.

Can anyone help me?

How to take average of every twelfth cell in a column
 

=(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*(A1:A40))) )/(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*1)))

You can reduce that to:

Array entered.

=AVERAGE(IF(MOD(ROW(A1:A40),F4)=0,A1:A40))

--
Biff
Microsoft Excel MVP


"dhstein" wrote in message
...
If F4 contains the value "12" then you can use this Array formula:

=(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*(A1:A40))))/(SUM((IF(MOD(ROW(A1:A40),$F$4)=0,1,0)*1)))


Array formulas are entered by typing the formula and instead of hitting
"Enter" key - hit "CTRL + SHIFT + ENTER" simultaneously. You can learn
about
array formulas he

http://www.cpearson.com/excel/ArrayFormulas.aspx



"uiowa" wrote:

Hi,

I am struggling to figure out how to take average of every twelfth cell
in a
column containing a very
list of numbers.

Can anyone help me?