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?
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?
Just thought about it (u3,u5,u7).
Thanks anyway!
=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.
Entia non sunt multiplicanda sine necessitate
thanks shg!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks