| View previous topic :: View next topic |
| Author |
Message |
akaigotchi
Newbie
Joined: 10 Jun 2007
Posts: 2
|
 Posted: Sun Jun 10, 2007 3:25 am Post subject: Count how many entries match criteria in column A AND B |
 |
|
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  Your help would be greatly appreciated...
Thanks for your help in advance
Regards
akaigotchi |
|
| Back to top |
|
 |
squenson
Super User
Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia
|
| Posted: Sun Jun 10, 2007 3:46 am Post subject: |
|
|
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 |
|
|
akaigotchi
Newbie
Joined: 10 Jun 2007
Posts: 2
|
| Posted: Sun Jun 10, 2007 3:51 am Post subject: |
|
|
| 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  I have been sitting on this for about 4 hours now
Regards
akaigotchi |
|
| Back to top |
|
|
|
