Formula that sums only the numbers in a range and ignores text
P Paul B Apr 25, 2006 #3 dlb, sum ignores text, =SUM(A1:A10) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
dlb, sum ignores text, =SUM(A1:A10) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003
