Formula required for a gas logbook

[Mark]

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

 

[Ragdyer]

One way:

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

RD

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

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

 

[David Biddulph]

You might try
=SUMIF(B4:B35,">3",F4:F35)-SUMIF(B4:B35,">=10",F4:F35)

 

[Teethless mama]

=SUM(SUMIF(A4:A35,{">3",">=10"},F4)*{1,-1})

 

[Mark]

Thank you for the help, but It did not work

=SUM(SUMIF(A4:A35,{">3",">=10"},F4)*{1,-1})

 

[Mark]

Thank you for the help, but I could not get it to work

 

[Mark]

Thank you for the help, it worked, you have saved me a lot of time.

 

[RagDyeR]

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