OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

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

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
joynerCN
General User
General User


Joined: 11 Jun 2008
Posts: 30

PostPosted: Sun Jan 11, 2009 9:12 pm    Post subject: Conditional: Count the number of rows where B#="text&qu Reply with quote

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?
Back to top
View user's profile Send private message
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Sun Jan 11, 2009 11:20 pm    Post subject: Reply with quote

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!)
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group