Return a positive sum from a column of negative numbers?

[HRVRAMER]

I am creating Invoices in Excel and exporting them into Quickbooks via IIF file. The total amount of the transaction has to equal (0)
........A....... B...... C
1 Quantity Rate Amount
2 _ -10__ 20.00 -200.00
3 __-5___ 10.00 -50.00
4 __-1___ 50.00 -50.00
Total Amount 300.00

I need a formula that will return the sum of all the negative numbers in column (C)

Thanks

 

[delaneyjm]

Maybe:

=ABS(SUM(C2:C4))

 

[HRVRAMER]

That not working.

 

[delaneyjm]

What exactly is not working? Can you be more specific?

 

[baitmaster]

=sumif(c:c,"<0")
or =-sumif(c:c,"<0")

 

[HRVRAMER]

I figured it out. C column was all merged cells. This happened because I import my data and to add the minus sign to the data in column C I madea column full of minus signs right beside it and merged the two.

The solution turned out to be; Copying the the merged cells and using "paste special" to paste only the values into a new column. The formula that you gave me worked by pushing shift+ctrl+enter.

Thanks for the help!

 

[HRVRAMER]

If you know a better way to turn a column of positive number into negative numbers, that would be a big help!

 

[mikerickson]

Put -1 in a remote cell.
Select that cell.
Copy
Select the range of cells with postitive values.
PasteSpectial/Arithmetic/Multiply

(clear the remote cell)