Thread: Find next value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgkgmg bgkgmg is offline
external usenet poster
 
Posts: 40
Default Find next value

I am trying to return a value in cell B3 from E5:E40 using the SUMIF formula.
In cell B4 I want to return the next value in E5:E40 that meet the same
criteria. Right now it is adding them together.

Thanks
Bobby