count colored cells

[Sharksfan]

we have a spreadsheet with six columns. The cells in the six columns have conditional formatting and change color based on the value in them. Colors are red, green, and yellow. I want to count the number green and yellow cells in a row. Can this be done? Below is an example, except the cells would be colored (not words) based on conditional formatting. I have tried creating a colorcount function, but because of conditional formatting it only sees them as normal white cells.

Months Sold	L6TTL	L6 SDC	LOC %	L6SDC CUST	AVG cost	count of Green and Yellow
Red	Red	Green	Green	Yellow	Green	4
Green	Green	Green	Green	Red	Yellow	5

<tbody>
</tbody>

 

[DRSteele]

You can use function COUNTIFS by mirroring all the conditions that trigger the CndFrmt. In other words, if AVG Cost is CndFrmt green because it meets a certain condition and LOC% is yellow because it meets some other condition, etc, use COUNTIFS with your six fields in your data as each of the arguments in COUNTIFS.

 

[kweaver]

If the values that trigger the background color are simply one number for yellow (e.g., 6) and one number for green (e.g., 4), then G2 (fill down) could be:

=COUNTIF(A2:F2,4)+COUNTIF(A2:F2,6)

For example, if Green's number could be either a 4 or 5, then this should count:

=COUNTIF(A2:F2,4)+COUNTIF(A2:F2,5)+COUNTIF(A2:F2,6)