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

--
pickamovi
-----------------------------------------------------------------------
pickamovie's Profile: http://www.excelforum.com/member.php...fo&userid=3210
View this thread: http://www.excelforum.com/showthread.php?threadid=52300

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" <(E-Mail Removed)> a
écrit dans le message de
news(E-Mail Removed)...
>
> hello all,
> i am new to excel.can somebody help me writing a formula for
> 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) or
> c1,c3,c5,c7,c9 ....
>
> thanks in advance
>
>
> --
> pickamovie
> ------------------------------------------------------------------------
> pickamovie's Profile:
http://www.excelforum.com/member.php...o&userid=32101
> View this thread: http://www.excelforum.com/showthread...hreadid=523008
>

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

--
pickamovi
-----------------------------------------------------------------------
pickamovie's Profile: http://www.excelforum.com/member.php...fo&userid=3210
View this thread: http://www.excelforum.com/showthread.php?threadid=52300

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" <(E-Mail Removed)> a
écrit dans le message de
news(E-Mail Removed)...
>
> 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 want
> the average to be displayed in a specified cell...
> thanks .
>
>
> --
> pickamovie
> ------------------------------------------------------------------------
> pickamovie's Profile:
http://www.excelforum.com/member.php...o&userid=32101
> View this thread: http://www.excelforum.com/showthread...hreadid=523008
>