Thread: NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default NEED A FORMULA THAT ADDS EVEN OR ODD ROW NUMBERS
For even rows:
=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=0),A1:A20)

For odd rows:
=SUMPRODUCT(--(MOD(ROW(A1:A20),2)=1),A1:A20)



"J Shamp" wrote:

I am looking for a formula that will sum even or odd row numbers
Reply With QuoteReply With Quote