how to write an average function when skipping rows?

**novice2430** · 09-21-2008, 12:45 PM

I'm using the function =average(u3:u7)
I want to space the rows, now the values will be in cells u3, u5, and u7 (not u3, u4, u5).
How can I write this formula to make it average every other cell?

**novice2430** · 09-21-2008, 12:47 PM

Just thought about it (u3,u5,u7).

Thanks anyway!

**shg** · 09-21-2008, 12:50 PM

=AVERAGE(IF(MOD(ROW(U3:U7), 2) = 1, U3:U7) )

This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.