Thread: sum alternate rows
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jovan Timotijevic[_2_] Jovan Timotijevic[_2_] is offline
external usenet poster
  
Posts: 12
Default sum alternate rows
To sum cells A1:A7 that are

EVEN: =SUM(IF(MOD(ROW(A1:A7),2)=0,A1:A7,0))
ODD: =SUM(IF(MOD(ROW(A1:A7),2)=1,A1:A7,0))

Ctrl+Shift+Enter to enter formula
Reply With QuoteReply With Quote