How can I add only the odd numbers in a column of numbers?
M Max Dec 2, 2005 #2 One way, assuming the col of numbers is within A1:A100 Try in say, B1: =SUMPRODUCT(--(MOD(A1:A100,2)=1),A1:A100) and for summing the even numbers, just switch the "MOD(...)=1", to "MOD(...)=0", i.e.: =SUMPRODUCT(--(MOD(A1:A100,2)=0),A1:A100)
One way, assuming the col of numbers is within A1:A100 Try in say, B1: =SUMPRODUCT(--(MOD(A1:A100,2)=1),A1:A100) and for summing the even numbers, just switch the "MOD(...)=1", to "MOD(...)=0", i.e.: =SUMPRODUCT(--(MOD(A1:A100,2)=0),A1:A100)
B B. R.Ramachandran Dec 2, 2005 #3 Hi, If your data are in the range A2:A101, in some other cell (e.g., B2) enter the following formula: it will add all the odd numbers in the column. =SUMPRODUCT((A2:A101)*(MOD(A2:A101,2)=1)) To add only even numbers, change the '1' at the end of the formula to '0') Regards, B. R. Ramachandran
Hi, If your data are in the range A2:A101, in some other cell (e.g., B2) enter the following formula: it will add all the odd numbers in the column. =SUMPRODUCT((A2:A101)*(MOD(A2:A101,2)=1)) To add only even numbers, change the '1' at the end of the formula to '0') Regards, B. R. Ramachandran
