+ Reply to Thread
Results 1 to 2 of 2

How to many a cell that groups cells based off of color

  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    New York City
    MS-Off Ver
    Office 2011 for OS X
    Posts
    8

    How to many a cell that groups cells based off of color

    Hello,

    Is there any way that I can make a cell that take the sum of all cells in a column that are a specific color? I want the sum, and the count of number of cells.

    For example. I am making all cells red of a product that was sold. Green for products that are available. The cells will be constantly updated, thus being switched from green to red. I want a cell that gives me the number or red and the number of green cells. Also a cell that gives me the sum of each group.

    Thanks!

    Dan

  2. #2
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: How to many a cell that groups cells based off of color

    Try these UDFs (I didn't write them but I use them a lot) this is borrowed from

    https://www.ablebits.com/office-addi...y-color-excel/

    Please Login or Register  to view this content.
    and the formula I think you are going to yse should look something like this
    Please Login or Register  to view this content.

    Hope this helps
    Bramz

+ 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. Replies: 3
    Last Post: 08-18-2014, 12:47 PM
  2. Hide groups of cells based on specific value in one cell
    By excelvice in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2014, 09:53 AM
  3. [SOLVED] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  4. How do i auto fill cell color based on other cells' color?
    By Kchatza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2012, 05:00 AM
  5. [SOLVED] Macro to color groups of cells based on column values
    By juskojj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2012, 10:53 AM
  6. Color cells based on cell value
    By BioBeaver in forum Excel General
    Replies: 3
    Last Post: 09-16-2010, 07:05 PM
  7. [SOLVED] sum cells based upon color of cell
    By karls in forum Excel General
    Replies: 2
    Last Post: 05-17-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1