You're welcome, and your feed-back is appreciated.
--

Regards,

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

"Mark" wrote in message
...
Thank you for the help, it worked, you have saved me a lot of time.

"Ragdyer" wrote:

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