Results 1 to 10 of 10

sum of all possible combinations

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    Baltimore
    MS-Off Ver
    Excel for Mac 2011
    Posts
    45

    sum of all possible combinations

    I have a worksheet where the columns represent types of medication and the rows are individual people.

    I need to total how many people have each combination of 12 medications. For example, how many have the combination of med1, med2 and med10; or the combination of med2, med5, med6, med7 and med8; etc. Just examples.

    See attached partial data file (hope it uploaded).

    Thanks for any advice, really appreciate the help!
    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. ODD and Even Combinations
    By Prit50 in forum Excel General
    Replies: 4
    Last Post: 05-29-2017, 02:59 PM
  2. Combinations
    By zak.horrocks in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2016, 07:39 AM
  3. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  4. Combinations
    By tazpyro1 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-09-2012, 01:44 PM
  5. Combinations
    By mthurman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2011, 03:48 PM
  6. Excel 2007 : Combinations
    By freehawk in forum Excel General
    Replies: 1
    Last Post: 12-18-2010, 12:05 PM
  7. Combinations
    By osprey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 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