Sum

[shibulal]

I have C column with the result of simple subtraction. (B-C)

The format goes like this

A B C D

1

2 500 100 400

3 800 300 500

4 700 900 -200

5 200 50 150


Now, I want the total of D column without calculating the minus figure in D4.

The answer must be 1050 instead of 850.

 

[Jack]

Try this and adjust the ranges to suit


=SUMPRODUCT((D2:D5)*(D2:D5>0))

 

[shibulal]

Thanks John.