Thread: sumif problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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