BINGO,
Awesome formula. Nailed the answer in one cell.
Any help in me understand this would be greatly appreciated.
Thanks
cs frolich
"Ragdyer" wrote:
For odd rows, starting at F5 down to F957, try this:
=SUMPRODUCT((MOD(ROW(F5:F957)-5,2)=0)*(F5:F957))
For even rows, starting at F6 down to F958, try this:
=SUMPRODUCT((MOD(ROW(F6:F958)-6,2)=0)*(F6:F958))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"csfrolich" wrote in message
...
I am attempting to add every other cell in a 958 row set of numbers.
For instance: =SUM (F5+F7+F9+F11+F13......F957) and then I want to add all
the even number rows, =SUM (F6+F8+F10+F12+F14......F958).
Any suggestions other than typing this formula out.
Thanks
|