hi max

thanks for your e-mail. i have tried it as below: but it appear error.

=AVERAGE(IF(MOD(P8:P235,2),P8:P235))

i have in 8 th row % 9th row values, 10th row %, 11th row values like that
until 235 row.


can u pls reply.
----------------------------------

"Max" wrote:

"Muralikrishnan" wrote:
i would like find out an aveage from A1:A500 (alternate rows only to say
like 1,3,5,7 and so on until 500th row)

Put in say, B1, array-enter the formula by pressing CTRL+SHIFT+ENTER,
instead of just pressing ENTER:
=AVERAGE(IF(MOD(A1:A500,2),A1:A500))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---