Excel VBA Tips
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment