| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Problem | New Users to Excel | |||
| =SUMIF Problem | Excel Worksheet Functions | |||
| =SUMIF Problem | Excel Discussion (Misc queries) | |||
| =SUMIF PROBLEM | Excel Programming | |||
| Sumif problem | Excel Programming | |||
Hybrid Mode
