+ Reply to Thread
Results 1 to 3 of 3

Seeking Formula to calculate percentages in spread sheet column by color

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    deep south
    MS-Off Ver
    Excel 2003
    Posts
    2

    Seeking Formula to calculate percentages in spread sheet column by color

    Happy New Year to everyone,

    It has been a while but need assistance in figuring % of cells in a spreadsheet total based on colors. See attached and thank you all for the assistance.

    Regards, EJ
    Attached Files Attached Files
    Last edited by bigdukesix; 01-18-2016 at 05:25 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Seeking Formula to calculate percentages in spread sheet column by color

    In E2, enter =COUNTIF($B$2:$B$200,D2)/COUNTA($B$2:$B$200) then fill the formula.

  3. #3
    Registered User
    Join Date
    03-05-2014
    Location
    deep south
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Seeking Formula to calculate percentages in spread sheet column by color

    Thank you JieJenn...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. [SOLVED] Create formula to calculate percentages
    By saffy48 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-15-2013, 01:21 AM
  3. Formula Needed to calculate 2 different percentages with limits...
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-07-2013, 04:59 PM
  4. formula to calculate 2 percentages in one cell
    By swissli78 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2013, 12:48 AM
  5. Replies: 1
    Last Post: 11-30-2005, 09:45 AM
  6. [SOLVED] how do I create a spread sheet to automatically calculate when I
    By wbinfo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-28-2005, 04:05 PM
  7. Replies: 5
    Last Post: 08-10-2005, 04:05 PM

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