Solved: average offset rows in a column

[neditheg]

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]

=AVERAGE(IF(MOD(ROW(D9:107),2)=0,0,D9:107))

[neditheg]

superb! thanks!

[neditheg]

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]

Try this array formula

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

[neditheg]

In this case I get the "#value!" error message

[Bob Phillips]

Because you didn't array-enter it as I said.