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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.