Sumif Deviation is positive

  • Thread starter Thread starter chg
  • Start date Start date
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
 
Kind of figured it out myself:

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

Thx for reading anyway
 
Back
Top