MS Excell Question?

Question

I have a column of numbers that represent the sum of ebay sales I made. Some of the numbers are negative sums because of a loss.
What is the formula for adding only the negative sums together. I can get a total for the positive sums because it deducts the negative sums when you add the column together, but cant get it to add just the negative sums. Ive tried "COUNTIF" less than $0.01(countif (x<"x"))and it says $1.00 no matter what the number is.
If this question is confusing , welcome to the club LOL.

Answer 1

The formula is:
=SUMIF(A1:A5,"<0")

Replace A1:A5 with the actual cell range for your data.

You probably have 1 negative value which explains why COUNTIF always says 1.

Answer 2

One way to do this is to add a couple more columns.

Let's say the colum that shows the totals is colum E for example.
On column F, use the if statement that states if the entry in coumn E is <=, enter -1, otherwise enter 0 (e.g. for row 10 if(E10<0,-1,0)). Now make colum G the product of the respective rows for column E * F (e.g. for row 10, colulmn F = E10 * F10. This will produce a column of values that are the absolute value of all of the negative numbers.

A total of the column will be the total you seek.

There may be other ways to do this but I beleive the above will do the job.

Answer 3

try the E or 3....its called Autosum.. Highlight the numbers one line at a time and press autosum, If your looking for the Exact formula I have failed that part the last 1 year in school. Try A1+A2 =sum