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.
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