How to Count or Sum cells with Colors

[Manny74]

Hi All,

I have rows 1 thru 21, with data in column B.

How would I count or sum the number of green cells?

I have tried to google this and want to keep this simple, so I'm hoping I don't need to use VBA....

Sorry, I had colors on my spreadsheet, but when I copied it onto the body of my post, the colors (light green) disappeared, so I made the font Arial black (ex. B2, B4, etc.), so you can pretend those are the light green cells I need to count/sum.....

1	B
2	62.09%
3	699
4	75.40%
5	57
6	0
7	0
8	58
9	88.73%
10	0%
11	1
12	71%
13	33
14	55.49%
15	90.00%
16	0.00
17	0.00
18	1.64
19	511
20	5.01
21	708

<tbody>
</tbody>

 

[Marcelo Branco]

What is the criterion to color the cells?

M.

 

[Scott T]

If the coloring is done by conditional formatting then you can use the same condition to sum the cells. If they are manual colored the you would need VBA.

 

[Fluff]

How are the cells being coloured?

 

[Manny74]

Well I used conditional formatting for each cell...
The user must meet a certain target for each cell (goal)

So for example, B2 (62.09), if it's equal to or greater than 50% then it would be green....

 

[Manny74]

Yes I used conditional formatting for all the cells.
So how would I used conditional formatting to count the numbers of green cells?
Keep in mind, each cell has a different target amount....

 

[Fluff]

You could use
=COUNTIF(B:B,">50.0%")

Although your description & data don't match

 

[Manny74]

I used conditional formatting.
Every cell represents the users score...I use conditional formatting to see which user met the target goal-score (green) and who did not...

 

[Joe4]

Numbers like 699 and 57 would be greater than 50%, so would also be highlighted.
So, how did those ones NOT get highlighted?
What is your exact Conditional Formatting formula?
Or is the CF rule only being applied on certain rows (and not all of them)?

 

[Marcelo Branco]

Yes I used conditional formatting for all the cells.
So how would I used conditional formatting to count the numbers of green cells?
Keep in mind, each cell has a different target amount....

Maybe something like this

	A​	B​	C​	D​	E​	F​
1​		Values​	Target​		Count​	Sum​
2​		62,09%​	50%​		7​	4,4271​
3​		699​	1000​
4​		75,40%​	60%​
5​		57​	1000​
6​		0​	1000​
7​		0​	1000​
8​		58​	1000​
9​		88,73%​	50%​
10​		0%​	0%​
11​		1​	1000​
12​		71%​	60%​
13​		33​	1000​
14​		55,49%​	50%​
15​		90,00%​	70%​
16​		0​	1000​
17​		0​	1000​
18​		1,64​	1000​
19​		511​	1000​
20​		5,01​	1000​
21​		708​	1000​

<tbody>
</tbody>

Formula in E2
=SUMPRODUCT(--(B2:B21>=C2:C21))

Formula in F2
=SUMPRODUCT(--(B2:B21>=C2:C21),B2:B21)

M.