Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbered Lists! | Excel Discussion (Misc queries) | |||
Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
How can I create consecutivlely numbered tickets? | Excel Worksheet Functions |