Thread: Sumif Deviation is positive
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chg chg is offline
external usenet poster
  
Posts: 15
Default 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
Reply With QuoteReply With Quote