problem adding positive numbers

**michaelwoosley** · 10-13-2012, 05:11 PM

Currently, I'm using a formula to add only positive numbers on my worksheet. the formula I am using in cell B19 is... =sumif(b12+b15+b18,">0", b12+b15+b18). There will be times that any one of these values may be negative and I only want to add positive values. I receive the infamous 'the formula you typed contains an error'. Would someone please assist with a correct formula syntax so I can get past what should be a seemingly easy solution.

Thanks

**Moo the Dog** · 10-13-2012, 05:46 PM

Not sure what you have between cells b12, b15 and b18, but the formula below will sum only the cells in the range of b12:b18 that are positive.

=SUMIF(B12:B18,">0")

**michaelwoosley** · 10-13-2012, 07:11 PM

Yes, that formula does work, however, in that range are numbers I don't want to add anything but the dark green cells.

B12 280.00
B13 TRUE
B14 25950.00
B15 1,505.10
B16 FALSE
B17 (41,050.00)
B18 (2,463.00)
B19 $27,735.10

In my example, I don't want to add row B18 because it is a negative number. I can use =sumif(b12:b18,">0") but I need a way to make sure ONLY B12, B15 and B18 are taken into consideration AND only added if positive. Lastly, I must be able to eliminate the other cells as part of the total. Long story short, I only need to concentrate on these 3 cells.

**Moo the Dog** · 10-13-2012, 07:40 PM

Well, there is this... pretty ugly though.

Formula:

Please Login or Register  to view this content.

**michaelwoosley** · 10-13-2012, 08:01 PM

You nailed it kind sir! And, it's not ugly as long as it works. Thank you very much for your help.

**Moo the Dog** · 10-13-2012, 08:09 PM

You're welcome! It's a formula only a mother could love... but you're right, it works!

**Cutter** · 10-14-2012, 11:42 AM

@ michaelwoosley

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.