About Us

SBecker

Thanks for your help...

"Eduardo" wrote:

Hi,
=sumproduct(--(a6:a50="Network")+(B6:B50="F"))

"SBecker" wrote:

I'm trying to create a formula that will count cells that contain and F, but
only if a different column equals a specified word. Example

Column A Pass/Fail
Network F
Strat 1 P
Strat 3 P
Network F
Strat 3 F
Strat 1 P

So how do I get it to look at all of column A and only count those that
equal Network and that column B (pass/fail) equals F? I've tried
if(a1:a6="Network",(countif(b1:b6),"F),""). It seems that the problem is the
ranges.

Any help would be great!
Thanks
Suzanne

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how copy formula that contains ranges so ranges do not overlap	Patty	Excel Worksheet Functions	1	November 20th 08 04:15 PM
Formula ranges	Metolius Dad	Excel Worksheet Functions	2	March 1st 07 07:14 PM
Date ranges in a sum formula	Marcus Caterino	Excel Worksheet Functions	2	June 26th 06 10:44 PM
Formula with ranges	Manos	Excel Worksheet Functions	3	May 23rd 06 10:41 AM
Different ranges in formula	Jan	Excel Worksheet Functions	6	March 29th 06 06:45 PM

Menu

About Us