How do I get the sum of only odd/even numbered cells in a column?
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 |
One way,
even =SUMPRODUCT(--(MOD(A1:A10,2)=0),A1:A10) odd =SUMPRODUCT(--(MOD(A1:A10,2)=1),A1:A10) -- Regards, Peo Sjoblom "Steve E" <Steve wrote in message ... 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 |
=SUM(IF(MOD(A1:A100,2)=0,A1:A100))
for even numbers, and =SUM(IF(MOD(A1:A100,2)=1,A1:A100)) for odd numbers. These are array formulae, so commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "Steve E" <Steve wrote in message ... 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 |
|
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com