Trying to sum result of a range but only if positive

Hi everyone,
I'm not great at this and I've stumped myself. I think I'm close though, just missing one part.
I'm trying to add up the results of rows 6-50 of the following:

(F6/C6*0.024)-50 + (F7/C7*0.024)-50 etc but ONLY if it's a positive value. So if subtracting 50 makes it negative, I need it to be ignored rather than subtract from the sum.

So far I have:
=SUM(IF(C6:C50<>0,((F6:F50/(C6:C50*0.024))-50)))
Which is working except the negative values. The first IF is only to stop division by zero for blank lines.
I've tried adding an extra IF ">0" statement but that results in SPILL!
I've tried adding a MAX(0,all that^) but it just returns the first line it finds, the sum doesn't seem to continue.

I'm really hoping someone can spot my mistake, or send me down a different rabbit hole!
Thanks!
-Byron

Please Login or Register  to view this content.

Can you make the example of the result that you want?

Thanks Jeff,
The second formula is the one I'm after. The 0.024 is in the denominator. The code you sent back is returning 0 right now, going over it but thanks!

Here's the relative part of the sheet with a few notes, I know it doesn't make a whole lot of sense but hopefully that explains a little.
Thanks again!

Originally Posted by BMagedanz

Thanks Jeff,
The second formula is the one I'm after. The 0.024 is in the denominator. The code you sent back is returning 0 right now, going over it but thanks!

Scratch that, just had to adjust a few parentheses to make it run the second formula and not only does it work perfectly, it's beautifully simplistic. THANK YOU!