View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default SUM odd/even Rows?

If you need a formula you could use this:
where A1:A18 is your range
for odd rows:
=SUMPRODUCT((MOD(ROW(A1:A18),2)=1)*(A1:A18))
for even rows
=SUMPRODUCT((MOD(ROW(A1:A18),2)=0)*(A1:A18))

hth
Carlo

On Jan 10, 8:53*am, TexJen wrote:
Is there a way to select a range, and then SUM only the odd # rows in that
range? *Or, even # rows?
thnx so much