Thread: Help with SUMIF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
  
Posts: 89
Default Help with SUMIF formula
Trying to get SUMIF formula to sum the values between D:1602 & D2620 if they
are greater than .15 but less than 1.65. Unfortunately, the formula below is
giving me zero for the result. (AB1 = .15, AB2 = 1.65). The idea is to be
able to change the min and max in AB 1 & 2 and have it sum only those cells
between the values)

=SUMIF(competition!D1602:D2620,OR(competition!D160 2:D2620AB1,competition!D1602:D1620<AB2))

Thanks for any help!

Irie
Reply With QuoteReply With Quote