Count contents of cells (by color)

[sassriverrat]

I've been reading the forums but haven't found quite what I want.

I have a column of cells that's a mix of green, red, and white colors. I'd like a way to count the contents of all of the green cells, and preferably it needs to auto update every time a cell changes color....so if a cell suddenly becomes green, the user doesn't have to change anything or reselect anything.

Thanks!

 

[Joe4]

How exactly is the color of the cells being set/changed?

 

[sassriverrat]

Cells change color based upon rule that sees if a neighboring cell in the row is equal to "yes, maybe, or no"

 

[Joe4]

Excellent. I was hoping that it was being updated by Conditional Formatting, as this would be very hard to do if it was manual color formatting.
All you need to do is use COUNTIF (or COUNTIFS) formula that use the same conditions as you do in Conditional Formatting to get your counts.
If you are having trouble figuring this out, please post your exact Conditional Formatting rules.

 

[sassriverrat]

Nope. I've been blanking for the last 40 minutes and it's been driving me crazy! Thank you!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[sassriverrat]

Ahhh maybe a bit more help.

 =Q9="Yes"

Applies:
=$B9:$Q1041

If, say, C9 = 10 and D9 =15, then I want the cell to say that because C9 and D9 are green, the cell equals 25.

 

[Joe4]

OK, if you actually want to SUM the values, and not COUNT the number of colored cells, then you just use the SUMIF or SUMIFS function with those conditions.

 

[sassriverrat]

Well that's where I've gotten stuck again. If I use name manager with get.cell(38,sheet_reference) then I can get it for cells that I fill, but not those that are filled conditionally....so I get stuck.

 

[Joe4]

Well that's where I've gotten stuck again. If I use name manager with get.cell(38,sheet_reference) then I can get it for cells that I fill, but not those that are filled conditionally....so I get stuck.

I don't quite follow what you mean.
Can you post an example and walk me through it?