How to sum only the positive numbers in Excel?
This video shows how to use SUMIF or SUMIFS.
This video shows how to use SUMIF or SUMIFS.
Transcript of the video:
How to SUM only the positive numbers in Excel?
You can use the SUMIF function.
SUMIF - now SUMIF is a lot older than SUMIFS.
But it's shorter.
So this is the range we want to add up.
Then comma.
Iin quotes, the criteria.
We want everything greater than zero.
That's the positive numbers.
And click Enter - 529.
Check this out.
There's two different functions you can use.
SUMIF with only two arguments.
Or the new SUMIFS that requires you to specify the sum range and the criteria range.
SUMIFS is better, I get it.
But it's longer and in this case with only one criteria, I'm going to go with SUMIF.
If you like this video, please visit TL.Page/MrExcel, scroll down, you'll find my group lessons and plenty more videos. Thanks for watching.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments in the comments below.
You can use the SUMIF function.
SUMIF - now SUMIF is a lot older than SUMIFS.
But it's shorter.
So this is the range we want to add up.
Then comma.
Iin quotes, the criteria.
We want everything greater than zero.
That's the positive numbers.
And click Enter - 529.
Check this out.
There's two different functions you can use.
SUMIF with only two arguments.
Or the new SUMIFS that requires you to specify the sum range and the criteria range.
SUMIFS is better, I get it.
But it's longer and in this case with only one criteria, I'm going to go with SUMIF.
If you like this video, please visit TL.Page/MrExcel, scroll down, you'll find my group lessons and plenty more videos. Thanks for watching.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments in the comments below.
