sum only the positive numbers

[Bjeenie]

hi,

i have a serie of numbers on a row.
and on the last cell i would like to have a sum of all the POSITIVE numbers on that row.

is there a big complex formula to do this?

thx!

[zbor]

Please rename your thread according to the rules

[karan]

Hi Bjeenie,

Considering that you have values from A1 to A10, the formula to get the sum of all the positive values in that range would be:

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

You can modify the range as per your requirement.

Regards,
Karan

[Bjeenie]

thanks for the fast reply!!
it works!

[DonkeyOte]

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

Karan, no need to repeat the A1:A10

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

will work just fine.

[karan]

Thanks a lot DonkeyOte

[crossroadsglass]

Quick and simple. Thank you very much!

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

In future make sure that you follow the rules, especially when a member reminds you to do so. I have edited the title this time, next time you may well find your question locked!

[zbor]

Also, make thread [solved] when you get solution.