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

CountIf Function on Multiple Sheets

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


Joined: 17 Jun 2010
Posts: 8

PostPosted: Fri Jun 18, 2010 11:35 am    Post subject: CountIf Function on Multiple Sheets Reply with quote

How do I use a countif formula on one sheet of a database when the data is on a second sheet? I want to be able to differentiate between blue, red, yellow etc... I am able to use a countif function to count all the the data in a cell but not specifically how many blue, red etc...

Here is what I have so far ... =COUNTIF(Sheet2!A1:A20,"blue")

Figure it out! Here it is ...

=COUNTIF(Sweeps.D3:D28;"pmnt")

Have fun counting.
Back to top
View user's profile Send private message Yahoo Messenger
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Sun Jul 04, 2010 7:38 am    Post subject: Reply with quote

To improve the content quality of the forum, please ...

Tag the thread as solved (edit the posting and add [Solved] in the subject line).
Forum admin/moderator or original poster can do this

Move the thread to the Calc subforum, where it belongs.
Forum admin/moderator action required
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 Math 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