Results 1 to 3 of 3

Thread: LibreOffice

  1. #1
    Join Date
    Feb 2013
    Beans
    2

    Question 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. #2
    Join Date
    Nov 2008
    Location
    Sussex, England
    Beans
    871
    Distro
    Lubuntu

    Smile Re: LibreOffice

    Quote Originally Posted by Crazy Bee View Post
    ...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. #3
    Join Date
    Feb 2013
    Beans
    2

    Talking Re: LibreOffice

    Quote Originally Posted by SteveDee View Post
    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 !!!

Bookmarks

Posting Permissions

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