How can I subtract a range of numbers from another number?
P Paul B Mar 9, 2007 #2 JS, maybe, something like this =B1-A1:A8 -- 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
JS, maybe, something like this =B1-A1:A8 -- 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
G Gary Brown Mar 9, 2007 #3 =B1-sum(A1:A8) -- HTH, Gary Brown [email protected] If this post was helpful to you, please select ''YES'' at the bottom of the post.
=B1-sum(A1:A8) -- HTH, Gary Brown [email protected] If this post was helpful to you, please select ''YES'' at the bottom of the post.
