sumif problem
 

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.

sumif problem
 

Check your other post.

Mark wrote:

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