Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Help Count and Percentages (2000 SR-1)

    I need help on two formulas.

    A simple data list will be filled with a list of people we have seen in our regional offices. Some people will need to be seen again within another 10 days.

    The data for the Follow Up Status will be one of four options

    Y = we have seen them for a follow up visit
    N = we haven

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula Help Count and Percentages (2000 SR-1)

    The fraction of "Y" in the entire group is:
    <pre>=COUNTIF(E3:E12,"Y")/COUNTA(B3:B12)</pre>


    The fraction of "Y" in the group with just Ys and Ns is:
    <pre>=COUNTIF(E3:E12,"Y")/(COUNTIF(E3:E12,"Y")+COUNTIF(E3:E12,"N"))</pre>


    Format them as percentage or multiply by 100 if you don't want to format.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Help Count and Percentages (2000 SR-1)

    Thank you very much. My first ideas regarding the formulas ran along your solutions but the word Percentages caused my wee brain to get up an leave the room.

    Again Thanks

Posting Permissions

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