Adding up negative numbers only

T

tonydepo

Ok, let me try to explain this problem. I have several cells a1 throug
a10. Each cell has a number, for ex. $10.00, ($5.00),etc. , sometime
this number is positive, sometimes it is negative. I want to only ad
all of the negative numbers in cells a1:a10 and put a total in cel
a11. How can I do this?

Thanks

Ton
 
R

Ron Rosenfeld

I meant:

=SUMIF(A1:A10,"<0",A1:A10)

Steve
Click to expand...

No, you were correct the first time. The last argument in SUMIF is optional,
and only required if the range to sum is different from the criteria range.


--ron
 
F

firefytr

Isn't that what I just said? ;)


Ron said:
No, you were correct the first time. The last argument in SUMIF i
optional,
and only required if the range to sum is different from the criteri
range.


--ro
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement accepting only positive values 1
Help to validate MULTIPLE numbers in one cell, not just the total 1
Excel - Adding positive or negative numbers in a column 5
Adding a negative number instead of substracting it 4
Subtotal data excluding negitive numbers. 3
How do I subtract a negative number from a positive number? 4
Excel - in a row of numbers, put last entered number Cell B2 7
Custom Number Format for text 13

Top