Sumif Deviation is positive

C

chg

I'd like to calculate the sum of all postive deviations of two time
series.
Is there a way to do this without additional calculations in seperate
column?
I tried this, but it doesn't seem to work

=sumif(C1:C100-B1:B100,">0")

Any suggestions?

Thy very much
 
C

chg

Kind of figured it out myself:

={SUM(IF((C1:C100-B1:B100)>0,C1:C100-B1:B100))}

Thx for reading anyway
 
Top