# How to calculate the fuel rate with fuel costs between 2 valuese

1. ## How to calculate the fuel rate with fuel costs between 2 valuese

So Column A is the week and B is the rate that fuel was at for that week. I need the Column H to be the returning value as the Column B would fall on or in between the start and end rates Column F and G. I manually typed row 2's to show how I would need the returning value to be   Register To Reply

2. ## Re: How to calculate the fuel rate with fuel costs between 2 valuese

Your Start and End dates are \$ values.  Register To Reply

3. Originally Posted by JieJenn Your Start and End dates are \$ values.
Im sorry I meant to say the rate in column C to look up where it would match to the start and end rates and return the last column.  Register To Reply

4. ## Re: How to calculate the fuel rate with fuel costs between 2 valuese

There is an extra space after your average price, you may want to remove the spaces first. Give this formula a try

=SUMPRODUCT((\$F\$2:\$F\$42<=B2)*(\$G\$2:\$G\$42>=B2),\$H\$2:\$H\$42)  Register To Reply