Results 1 to 13 of 13

Nested if statatement + count

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    new york
    MS-Off Ver
    Excel 2003
    Posts
    62

    Nested if statatement + count

    Hello friends,

    I am new to nested if statement. I will like to see how many people in my data are ELIGIBLE for contraception services and what is the percentage of all my participants. In order for my participants to be ELIGIBLE, they have to be currently active, they can not be pregnant, and they can not be seeking pregnancy. My goal is to have a table in tab 2 that summarizes this info (# eligible and % of total). My idea was to create a new column (eligible) in my dataset with the nested if statements. Then in tab , I will count how many are eligible and generate the percentage. What will be a nice way to do this. I want to impress my supervisor.


    Thank you in advance.
    Marvin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Nested count and total?
    By srwafu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2012, 09:24 AM
  2. [SOLVED] "IF" statatement help while using checkboxes
    By sourbeer in forum Excel General
    Replies: 9
    Last Post: 06-07-2012, 01:27 PM
  3. Nested AND or IF inside of count
    By wmatthai in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-26-2010, 03:48 PM
  4. Nested Count IF Function
    By LLori998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2008, 05:20 PM
  5. Nested count and vlookups
    By Chrisnelsonusa in forum Excel General
    Replies: 1
    Last Post: 06-06-2005, 03:05 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1