Conditional: Count the number of rows where B#="text&qu

[joynerCN]

I've got a list of a few hundred rows. I want to count how many times a certain value appears in Column B AND there is any text in Column C.

So, for the following column B and C...
Apple None
Banana
Pineapple None
Strawberry None
Apple None
Banana
Pineapple
Strawberry None

This would count 2 if it was counting Apple or Strawberry, 1 for Pineapple, 0 for Banana.

I've looked into the COUNTIF function, but I can't figure how to make it work this way. Any tips?

[Robert Tucker]

Block the rows and columns including their headings (e.g., Fruit, Text) with your mouse and go to:

Data>Filter>Standard Filter

Field Name -> Text
Condition -> =
Value -> not empty

Block new table created with entries which only have text and copy/paste it somewhere else. You can then use COUNTIF.

(Maybe wait to see if any heavier Calc users have any slicker ideas!)
_________________
LibreOffice 3.6.6 on Fedora 18, LibreOffice 4.0.2 on Ubuntu 13.04 (Double Boot)