sumif problem

[Mark]

Please can anyone help.
at present I am usin a formula =SUMIF(B4:B35,">3",F4:F35). I need to expand
it so that it wil allow me to use >3 but <10.
Column B is gas %, column F is the pressure of the gas. It should then add
all the pressures in column F that are larger than 3% and less than 10%.
Assistance will be appreciated.

 

[Dave Peterson]

Check your other post.

Please can anyone help.
at present I am usin a formula =SUMIF(B4:B35,">3",F4:F35). I need to expand
it so that it wil allow me to use >3 but <10.
Column B is gas %, column F is the pressure of the gas. It should then add
all the pressures in column F that are larger than 3% and less than 10%.
Assistance will be appreciated.