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

Count how many entries match criteria in column A AND B

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


Joined: 10 Jun 2007
Posts: 2

PostPosted: Sun Jun 10, 2007 3:25 am    Post subject: Count how many entries match criteria in column A AND B Reply with quote

Hello everybody,

I am pretty new to Calc so plz forgive me if this has been answered before:

I have the following list:

Column A contains the gender encoded as either M or F
Column B contains the age of a person in years

I now want to count all entries that are, e.g gender F and 24 years of age.

Sorry, but I am simply stuck here Smile Your help would be greatly appreciated...

Thanks for your help in advance

Regards
akaigotchi
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Sun Jun 10, 2007 3:46 am    Post subject: Reply with quote

If your range goes from A1 to B11:
Code:
=SUMPRODUCT(A1:A11="F";B1:B11=24)

_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
akaigotchi
Newbie
Newbie


Joined: 10 Jun 2007
Posts: 2

PostPosted: Sun Jun 10, 2007 3:51 am    Post subject: Reply with quote

squenson wrote:
If your range goes from A1 to B11:
Code:
=SUMPRODUCT(A1:A11="F";B1:B11=24)


THANKS ALOT!!!!!

Your perfect answer helped me save a lot of time Very Happy I have been sitting on this for about 4 hours now Smile

Regards
akaigotchi
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