Posted to microsoft.public.excel.programming

Mark

external usenet poster

Posts: 989

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF Problem	tuafc	New Users to Excel	2	August 25th 09 04:50 PM
=SUMIF Problem	doctorjones_md	Excel Worksheet Functions	2	July 11th 06 11:42 AM
=SUMIF Problem	doctorjones_md	Excel Discussion (Misc queries)	1	July 8th 06 08:32 AM
=SUMIF PROBLEM	doctorjones_md	Excel Programming	0	July 8th 06 04:44 AM
Sumif problem	GregR	Excel Programming	10	June 24th 05 11:57 PM

All times are GMT +1. The time now is 06:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us