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
Bookmarks