PDA

View Full Version : Solved: average offset rows in a column



neditheg
07-19-2012, 06:59 AM
Hello,

I want a formula in cell D5 which should calculate average value every two cells from rabge D9 to D107.

I've attached an example file to make this easier.

Thanks!

CodeNinja
07-19-2012, 07:31 AM
=AVERAGE(IF(MOD(ROW(D9:107),2)=0,0,D9:107))

neditheg
07-19-2012, 07:31 AM
superb! :) thanks!

neditheg
07-20-2012, 02:23 AM
hmm I have a little problem with this solution :) the average value ...is not the real one:) I can't say ..why... :)

I'll attach the file to make this easier:)

thanks!

Bob Phillips
07-20-2012, 02:37 AM
Try this array formula

=AVERAGE(IF((MOD(ROW(D9:D107),2))*(D9:D107<>""),D9:D107))

neditheg
07-20-2012, 02:40 AM
In this case I get the "#value!" error message

Bob Phillips
07-20-2012, 04:08 AM
Because you didn't array-enter it as I said.