hi max - again it shows error (value#)
the following data i have in excel :

salary :
8th row - 2%
9th row - 2,600
10th - 3%
11th row - 3,315
12th 402 - 4%
13th row - 7,306
14th row - 5%
15th row - 1,680
16th row - 6%
17th row - 3,276

like that until 235 row (some employee row may not have figures for the
salary increase)

here i have to find what is the average % salary for the given employees.

\can u pls reply.


"Max" wrote:

Sorry, the earlier was wrong

You could try, array-entered in say, Q8:
=AVERAGE(IF((MOD(ROW(P8:P235),2)=0)*(P8:P235<""), P8:P235))
to derive average of the 8th, 10th, 12th, etc rows in col P

Conversely, this, array-entered:
=AVERAGE(IF((MOD(ROW(P8:P235),2)=1)*(P8:P235<""), P8:P235))
will yield the average of the 9th, 11th, 13th, etc rows in col P
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Muralikrishnan" wrote:
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.
----------------------------------