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
Thanks in advance