Counting cells that match 2 criteria

[Guest]

I have serveral columns of Data. In Col B some rows contain "PC". Col F
contains a forumla that returns TRUE or FALSE. I want to count the number of
times "PC" appears in col B but only when FALSE is in col F.
I have used this type of formula many times but only when there is just text
in col F ie =SUMPRODUCT((FINAL1!B2:BY5000="PC")*(FINAL1!F2:F5000="Customer"))

The formula in col F is =AND(B2="PC",D2="PC")
I would be grateful for any help.

 

[Don Guillett]

try just adding the parameter ie:
=SUMPRODUCT((B9:B12="a")*(G9:G12=FALSE))

 

[FrodeOlsen]

try just adding the parameter ie:
=SUMPRODUCT((B9:B12="a")*(G9:G12=FALSE))

--
Don Guillett
SalesAid Software






- Show quoted text -

Did you ever try using the COUNTIF function?
I find that function very handy when I want to count the number of
times that "particular" cell content excists.
However this is a very slow calculation if you have many lines, like
2000+.



Frode

 

[Don Guillett]

Wouldn't work well here

 

[Guest]

Thanks to both of you for your replies. Sumproduct worked perfectly. (I had
tried this formula previously but had put inverted comas around FALSE)

 

[Don Guillett]

Glad to help