One way:

=Sumproduct((B4:B353)*(B4:B35<10)*F4:F35)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Mark" wrote in message
...
Please can someone help.
I have been using the following formula =SUMIF(B4:B35,"3",F4:F35)
Column B is the gas % and column F pressure so it would add up all the
pressures of gas more than 3%.
What I wish to do is do the same thing but stipulte 3 but <10 so it will
add the pressures larger than 3 but smaller than 10. Can anyone assist
please