1. First Cup of Ubuntu
Join Date
Feb 2013
Beans
2

## LibreOffice

Hi
In Libreoffice calc : how to calculate the frequency of certain information in a column that meet certain criteria in another column for example :
how to calculate number of persons between age 10 and 20 that took 1 dose of a drug in the following table.

2. ## Re: LibreOffice

Originally Posted by Crazy Bee
...how to calculate number of persons between age 10 and 20 that took 1 dose of a drug in the following table...
Here is one way:-
In C2 type:-
=IF((A2>9) AND (A2<21) AND (B2=1),1,0)
Then replicate this in rest of C column (pull down the cross from lower right corner of C2 as far as row 12).
Then sum this column.

3. First Cup of Ubuntu
Join Date
Feb 2013
Beans
2

## Re: LibreOffice

Originally Posted by SteveDee
Here is one way:-
In C2 type:-
=IF((A2>9) AND (A2<21) AND (B2=1),1,0)
Then replicate this in rest of C column (pull down the cross from lower right corner of C2 as far as row 12).
Then sum this column.
than you very much SteveDee it worked !!!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•