Sum of numbers - need to ignore negative numbers

[RodneyW]

On cell G120, I am summing G3:G119. Some of the numbers between G3 and G119 are negative numbers. Rather than subtracting that number from the total, I want any place where there is a negative number for it to be calculated as if it was 0 rather than a negative number. For example, if G3 - G7 was the range I was looking at and the numbers were G3 = 2 and G4 = 6 and G5 = 10 and G6 = -5 and G7 = 20, G8 where the sum should be would = 26 (2+6+10+20) because it ignores the -5 in G6.

Thanks in advance

 

[Fluff]

How about
=sumif(G3:G7,">0")

 

[RodneyW]

That looks like it might work, thank you

 

[Fluff]

You're welcome & thanks for the feedback.