Hi,
Try this
=sumproduct((C1:C100-B1:B100)*(C1:C100-B1:B1000))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"chg" wrote in message
...
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