Find next value

  • Thread starter Thread starter bgkgmg
  • Start date Start date
B

bgkgmg

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
 
In sh1 B3:B40 I would like to return value that meet certain criteria from
sh2 and am using SUMIF formula. In sh2 Range C5:C40 Criteria "C1" Sum
Range D5:D40. I would like the first value in sh2 col D to copy to sh1B3,
the next value in B4 and so on.
Thanks
 
Back
Top