Prev: Pages in Inline frames
Next: Text box
From: skygazer on 29 Apr 2010 09:58
How do I add only the negative numbers in a column of positive and negative
numbers?
From: Ronx on 29 Apr 2010 10:21
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 :
> How do I add only the negative numbers in a
> column of positive and negative numbers?


From: Kathleen Anderson on 29 Apr 2010 10:24
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


"skygazer" <skygazer(a)discussions.microsoft.com> wrote in message
news:D541E306-2338-4C6C-9321-06C95651DD93(a)microsoft.com...
> How do I add only the negative numbers in a column of positive and
> negative
> numbers?



From: "Trevor Lawrence" Trevor on 29 Apr 2010 20:38
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

--
Trevor Lawrence
Canberra
Web Site http://trevorl.mvps.org
"skygazer" <skygazer(a)discussions.microsoft.com> wrote in message
news:D541E306-2338-4C6C-9321-06C95651DD93(a)microsoft.com...
> How do I add only the negative numbers in a column of positive and
> negative
> numbers?


 | 
Pages: 1
Prev: Pages in Inline frames
Next: Text box