Search This Blog

Wednesday 20 June 2012

FORMULA TO SUM ALL EVEN NUMBERS BETWEEN 1 TO 100

 Array Formula:

=SUM(ROW(1:100)*ISEVEN(ROW(1:100)))

Press   Ctrl+Shft+Entr.

No comments:

Post a Comment