Find next value

[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

 

[Gary''s Student]

What formula are you using in B3 ?

 

[bgkgmg]

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 D540. I would like the first value in sh2 col D to copy to sh1B3,
the next value in B4 and so on.
Thanks