Thread: Sumif Help Please
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
  
Posts: 56
Default Sumif Help Please
... the following formula ... is only valid if the value in
row 5 is greater than the value in row 2.
Otherwise, I need to calculate the reverse

Maybe something like this would help:
=IFERROR((ABS(D5-D2)*D4 + D19*D20)/D21, "")
Reply With QuoteReply With Quote