Results 1 to 6 of 6

Percentages based on more than one column of data.

Threaded View

  1. 01-30-2016, 11:43 PM #1
    InkyDrinky
    InkyDrinky is offline
    Registered User
    Join Date
    12-26-2015
    Location
    Las Vegas
    MS-Off Ver
    2013
    Posts
    56

    Percentages based on more than one column of data.

    Your Excellencies,

    This project is all dynamic ranges as you can see in the VBA in my file... the snippet is attached.

    I need the percentage of "Specials" in Column "D" that also have a "Y" in column "I" to calculate into a percentage of total Specials delivered within the delivery window.

    So if 2 Specials were in column "D" and only 1 had a "Y" in column "I" then the result would be 50%...

    Capture.PNG


    Any takers?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Projection based on 2 sets of data with percentages
    By ziggyztz in forum Excel General
    Replies: 2
    Last Post: 10-08-2015, 09:48 AM
  2. [SOLVED] Ranking a column of percentages based on the cells that meet criteria (between 100 to 103)
    By scotlandsneo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2015, 09:24 AM
  3. Position based on 3 different Percentages
    By oluagbe1 in forum Excel General
    Replies: 4
    Last Post: 02-26-2015, 04:01 PM
  4. [SOLVED] Calculate percentages based on cell color in column
    By joker4life88 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 06:08 AM
  5. [SOLVED] Subtotals based on percentages
    By Alx77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2013, 12:00 PM
  6. [SOLVED] IF Formula based on percentages
    By techteam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2012, 10:52 AM
  7. Help with if statements based on percentages
    By mfrey0118 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 06-18-2009, 03:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1