Sumif Deviation is positive
 

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

Sumif Deviation is positive
 

Kind of figured it out myself:

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

Thx for reading anyway

Sumif Deviation is positive
 

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