how to sum the even numbers only ????????
suppose that i have these values in column A1,2,3,4,5,6,7,8,9,10,11i need to sum the even numbers 2,4,6,8,10 and sothats it
There are at least 2 approaches.One isPut in another column ( say your numbers are in A3 to A10) put in B3=if(mod(A3,2)= 0,A3,0)Copy this down to B10Sum B3:B10The other is to build a function which is given a range as a parameter andsteps through each cell in the rangeTesting if it is evenAdding it if it isReturning the total
Another way would be to use a conditional array...say you have valuesin range a1:a12, you would enter the summation formula in a13 as follows:=SUM(IF(MOD(A1:A12,2)=0,A1:A12))to get the formula to work, you MUST hold down the <Ctrl><Shift> then<Enter>. The result formula would have two brackets around theformula like below...{=SUM(IF(MOD(A1:A12,2)=0,A1:A12))}the result should be 30
but i need to use one formula in one cell only to sum all evennumbers in specific column