how to sum even numbers only
J JE McGimpsey Apr 28, 2007 #2 omarhaji said: how to sum even numbers only Click to expand... One way (array-entered: CMD-RETURN): =SUM(IF(MOD(A1:A10,2)=0,A1:A10))
omarhaji said: how to sum even numbers only Click to expand... One way (array-entered: CMD-RETURN): =SUM(IF(MOD(A1:A10,2)=0,A1:A10))