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

Find next value
 

What formula are you using in B3 ?
--
Gary''s Student - gsnu2007

Find next value
 

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

"Gary''s Student" wrote:

What formula are you using in B3 ?
--
Gary''s Student - gsnu2007