Using min and if formula I would like to get cost based off of the start and end date.

Originally Posted by David713

No, this did not work.I do not have a column M:M.

I took M:M from your original post, but you can change it. The important part is the conditional tests, highlighted in RED here:

Formula:

=MIN(IF(($A2>=$E$2)*($A2<=$F$2)*($B:$B=$B3),$M:$M,FALSE))

Also, make sure you press CTRL+SHIFT+ENTER after you paste the formula in the Formula Bar.