View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chg chg is offline
external usenet poster
 
Posts: 15
Default 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