Thread: How do I get the sum of only odd/even numbered cells in a column?
View Single Post
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
On Thu, 3 Mar 2005 06:37:09 -0800, "Steve E" <Steve
wrote:

I need help with the formula to sum up only the odd or even numbers in a
column. I appreciate any help that you can provide.

Thanks,
Steve

Odd: =SUMPRODUCT(MOD(A1:A25,2)*A1:A25)
Even: =SUM(A1:A25,-SUMPRODUCT(MOD(A1:A25,2)*A1:A25))


--ron
Reply With QuoteReply With Quote