Thursday, December 17, 2009

Is there any way to clear out just negative numbers in a row in an excel sheet?

I am trying to seperate the negative number from the positive numbers so I can add up payments sent and payments received in a excel spreadsheet. Is there any way to do that? I already know how to add up all the numbers in a row and it would save alot of time if I can have excel delete out the positive numbers and leave the negative numbers so I don't have to do it myself.Is there any way to clear out just negative numbers in a row in an excel sheet?
Select all the cells you want to remove the negative numbers





Ctrl+H to open Find and Replace


-Find What: -*


-Replace with: (leave blank)


-Replace All





On another note: if you want to sum only positive values in a row e.g. A1 to H1...


=SUMIF(A1:H1, ';%26gt;0';)





Sum only negative values in a row ...


=SUMIF(A1:H1, ';%26lt;0';)Is there any way to clear out just negative numbers in a row in an excel sheet?
Go to http://www.asap-utilities.com and download and install the latest version. It's an add in for excel that starts when excel starts and gives you loads of useful utilities, one of which is Conditionally select cells, by value, less than and enter 0 for your value. It then selects every cell in your selected range that has a negative number in it. Once selected you can do what you want with them.
Just do a sort using the column with the numbers as the key and ascending order.


All of the negative numbers will be moved to the first rows. If you want positives first then use descending order.

No comments:

Post a Comment