S skygazer Apr 29, 2010 #1 How do I add only the negative numbers in a column of positive and negative numbers?
R Ronx Apr 29, 2010 #2 Suggest you ask in a forum or newsgroup where Excel experts hang out. frontpage.client is for FrontPage - a website editing application. -- Ron Symonds Microsoft MVP (Expression Web) http://www.rxs-enterprises.org/fp/wf-menu.aspx skygazer submitted this idea :
Suggest you ask in a forum or newsgroup where Excel experts hang out. frontpage.client is for FrontPage - a website editing application. -- Ron Symonds Microsoft MVP (Expression Web) http://www.rxs-enterprises.org/fp/wf-menu.aspx skygazer submitted this idea :
K Kathleen Anderson Apr 29, 2010 #3 You might try asking this question in one of the Microsoft Excel Forums at: http://social.answers.microsoft.com/Forums/en-US/category/officeexcel -- ~ Kathleen Anderson Microsoft MVP - Expression Web Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others
You might try asking this question in one of the Microsoft Excel Forums at: http://social.answers.microsoft.com/Forums/en-US/category/officeexcel -- ~ Kathleen Anderson Microsoft MVP - Expression Web Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others
T Trevor Lawrence Apr 30, 2010 #4 Well, I tried the following and I got the sum of the negatives -2 2 -3 5 4 5 5 5 6 5 -7 12 The first column is J2,J3 , etc The formula in the second column is =IF(J2<0,+K1-J2,+K1) which is copied down. An Excel group may have better suggestions
Well, I tried the following and I got the sum of the negatives -2 2 -3 5 4 5 5 5 6 5 -7 12 The first column is J2,J3 , etc The formula in the second column is =IF(J2<0,+K1-J2,+K1) which is copied down. An Excel group may have better suggestions
