Sumif Deviation is positive

[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

 

[chg]

Kind of figured it out myself:

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

Thx for reading anyway

 

[Ashish Mathur]

Hi,

Try this

=sumproduct((C1:C100-B1:B100)*(C1:C100-B1:B100>0))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com