This one sums the even numbered rows in Column A - rows 31 to 51...
=SUM(IF(MOD(ROW(A31:A51),2)=0,A31:A51))
It is an array formula and must be entered using Ctrl + Shift + Enter
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"TexJen"
wrote in message
Is there a way to select a range, and then SUM only the odd # rows in that
range? Or, even # rows?
thnx so much