Greetings.
My question is, how can I use IF in SUM function, or use some other function, to calculate only the positive values and ignore the negative values.
For example. I want to calculate the monetary values in a column, and I only want excel to sum values higher than 0 and ignore the ones lower the 0. How can it be done?
Last edited by Rocksteady; 03-30-2013 at 05:45 AM.
Try
=SUMIF(A2:A100,">0",A2:A100)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
If the criteria range and the sum range are the same then you can do it like this:Originally Posted by Fotis1991
=SUMIF(A2:A100,">0")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It worked. Thank you.
You're welcome. Thanks for the feedback!
..And this one? Does not works?
=SUMIF(A2:A100,">0",A2:A100)
This works also Fotis1991. It was just easier to exclude one more line in the formula. But it works the same. Thank you.
@ Rocksteady
OK. Biff..
That is the KISS method.
Hoping that i don't express the last "S"...
Regards
I do it quite often!Hoping that i don't express the last "S"...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks