Thread: SUM odd/even Rows?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default SUM odd/even Rows?
Even =SUMPRODUCT((A1:B10)*(MOD(ROW(A1:B10),2)=0))


Odd =SUMPRODUCT((A1:B10)*(MOD(ROW(A1:B10),2)<0))


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 15:53:43 -0800, 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

Reply With QuoteReply With Quote