Results 1 to 8 of 8

Calculating percentage with 1 condition, and percentage of these who has 2. condition

Threaded View

  1. #1
    Registered User
    Join Date
    11-23-2020
    Location
    Copenhagen
    MS-Off Ver
    Office16
    Posts
    6

    Calculating percentage with 1 condition, and percentage of these who has 2. condition

    I have a matrix (spreadsheet) of patients who can have up to 5 diagnoses of several different diagnoses.

    I have the patients in the rows and in the columns I have 1. diagnosis, 2. diagnosis etc. in which several different diagnoses (A-F) can be assigned (see attached example spreadsheet).
    The diagnoses come in random order.

    I would like to calculate how big a percentage who has diagnosis A of the total number of patients, and then I would like to calculate how big a percentage (of total) who has diagnosis A and 1 other diagnosis, and how many who has diagnosis A and 2 other diagnoses etc..
    The same for diagnoses B, C, etc.

    Thus, getting a summary who shows something like this:
    Diagnosis A: 45% of total population.
    Diagnosis A with 1 other diagnosis: 20 % of total population
    Diagnosis A with 2 other diagnoses: 5 % of total population
    Diagnosis A with 3 other diagnoses: 1 % of total population
    Diagnosis B: e.g. 10 % of total population.
    Diagnosis B with 1 other diagnosis: 8 % of total population
    etc.

    I cannot get my head around how to do this.

    Is this somehow possible to do using Pivottable or the countifs function?

    I would really appreciate your help, thank you!
    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. [SOLVED] Multiple If Condition with Percentage
    By sg2209 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-07-2018, 12:31 PM
  2. Separate Percentage condition required
    By Saikrishna12345 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2018, 11:01 PM
  3. Finding percentage when a condition is met
    By Adamlee in forum Excel General
    Replies: 3
    Last Post: 03-10-2015, 01:05 PM
  4. Replies: 0
    Last Post: 02-18-2015, 04:45 PM
  5. calculating percentage of percentage
    By zinneken in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-10-2013, 10:12 AM
  6. Replies: 11
    Last Post: 12-30-2012, 01:47 PM
  7. Calculating a percentage with the end percentage in mind
    By Shadowshady in forum Excel General
    Replies: 2
    Last Post: 06-17-2006, 04:45 AM

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