+ Reply to Thread
Results 1 to 4 of 4

Please help! Counting values in specific colored cells

  1. #1
    Registered User
    Join Date
    02-08-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Please help! Counting values in specific colored cells

    Hi guys,

    I need a way to calculate the values within a colored cells without using sum and manually selecting the cells.

    As you can see, in cell B31, this is the sum of the values in the red cells divided by 7.5.

    I also need this for B34 but for blue cells.

    Please see attached file.

    sample.xlsm

    Please help! :)

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Please help! Counting values in specific colored cells

    VBA can determine the colour of a cell.
    Or you may be able to create a Conditional Format and use the same condition in your SUM formula
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Please help! Counting values in specific colored cells

    Look at this link:

    http://www.exceltip.com/st/Sum_by_co...Excel/517.html
    Click on star (*) below if this helps

  4. #4
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Please help! Counting values in specific colored cells


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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