S
SBecker
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
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