average of different cell values (regular internval)

[pickamovie]

hello all,
i am new to excel.can somebody help me writing a formula fo
calculation the average of intermitnet values...

for example in a column C...
if i need average of c2,c4,c6,c8,c10 (at regular intervals) o
c1,c3,c5,c7,c9 ....

thanks in advanc

 

[Ardus Petus]

Assuming your data lays in C1:C25:

SUMPRODUCT(C1:C25,--(MOD(ROW(X1:C25),2)=0))/COUNTA(C1:C25)

You can adjust the value of 2nd parameter of MOD (here:2)

HTH
--
AP

"pickamovie" <[email protected]> a
écrit dans le message de
news[email protected]...

 

[pickamovie]

hi AP first of all thanks for the reply..
i think u misunder stood my problem..
here is the example
column C..
i want the everage of c1,c3,c5,c7,c9 with an interval (here 2)..i wan
the average to be displayed in a specified cell...
thanks

 

[Ardus Petus]

Sorry: I did not dvide by the proper number.

See example : http://cjoint.com/?dqm0KXjuq0

A1 contains my formula:
=SUMPRODUCT($C1:$C9,--(MOD(ROW($C1:$C9),2)=1))/SUMPRODUCT(--(MOD(ROW($C1:$C9
),2)=1))

As proof-ckecking, B1 contains =AVERAGE(C1,C3,C5,C7,C9)

HTH
--
AP

"pickamovie" <[email protected]> a
écrit dans le message de
news[email protected]...