formula in excel to skip cells having - number and add only +
|
formula in excel to skip cells having - number and add only +
anthonylaw, maybe this, if not please provide more information
=SUMIF(A:A,"0") -- 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 "anthonylaw" wrote in message ... |
formula in excel to skip cells having - number and add only +
Paul, did you have to do something tricky to respond? I keep getting an
error when I try to reply to the original post. I think it is because there is no text in it. "Paul B" wrote: anthonylaw, maybe this, if not please provide more information =SUMIF(A:A,"0") -- 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 "anthonylaw" wrote in message ... |
formula in excel to skip cells having - number and add only +
Sloth, no, just hit reply to list, using outlook express at this time
-- 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 "Sloth" wrote in message ... Paul, did you have to do something tricky to respond? I keep getting an error when I try to reply to the original post. I think it is because there is no text in it. "Paul B" wrote: anthonylaw, maybe this, if not please provide more information =SUMIF(A:A,"0") -- 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 "anthonylaw" wrote in message ... |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com