Thread: How do I add values only in odd numbered rows in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
  
Posts: 1,397
Default How do I add values only in odd numbered rows in Excel?
one way
=sumproduct(--(mod(row(A1:A100),2)=1,a1:a100)
for odd rows
....=0... for even rows

"baylor basketball" wrote:

I need to sum all the values in alternating rows...i.e. all odd or even rows,
or all odd or even columns. How do I type in this formula?
Reply With QuoteReply With Quote