martin - i tried & solved the issue.
thank you for the suggestion.

honestly i feel, this kind of discussion solves many issues. i enjoyed it
yesterday. this is the first time i am using it.

"MartinW" wrote:

Hi Murali,

You may be able to use a helper column like this.

If column Q is not blank insert a new one.
Then in Q8 put =P8
Then highlight both P8 and P9
Grab the fill handle and drag down to the end of your data
Then just average column Q.

HTH
Martin



"Muralikrishnan" wrote in message
...
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.
----------------------------------