find out average even rows in a particular range

  • Thread starter Thread starter Muralikrishnan
  • Start date Start date
M

Muralikrishnan

hi can some one help me to know
i would like find out an aveage from A1:A500 (alternate rows only to say
like 1,3,5,7 and so on untill 500th row)
 
Muralikrishnan said:
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)
Click to expand...

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))

---
 
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.
----------------------------------
 
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
 
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-
great. superb...
first the same reply no values.
second time i read ur lines ...and applied ctrl shift enter... now the % is
coming.
great superb. my work has be come so much so much easier.

otherwise i am gone case.

thank you very much

muralikrishnan
 
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
 
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.
 
Back
Top