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.....


[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"] 1[/TD]
[TD="class: xl75, width: 64"]B[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="class: xl68"]62.09%[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="class: xl69"]699[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="class: xl68"]75.40%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="class: xl70"] 57[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="class: xl63"]0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="class: xl70"] 0[/TD]
[/TR]
[TR]
[TD="align: right"] 8[/TD]
[TD="class: xl63"] 58[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="class: xl64"] 88.73%[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="class: xl65, width: 64"] 0%[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="class: xl71, width: 64"]1[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="class: xl66"]71%[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="class: xl67, width: 64"] 33[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="class: xl64"] 55.49%[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="class: xl64"] 90.00%[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="class: xl72"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="class: xl73"]0.00[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="class: xl72"]1.64[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="class: xl74"]511[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="class: xl72"]5.01[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="class: xl70"]708[/TD]
[/TR]
</tbody>[/TABLE]

 

[Manny74]

Ok so I added some more data, to try to elaborate....
For each user, I have different items they are responsible with different goals that has to be met (Column B & C)
Column D represents their scores-data....
For Discharge %, when he/she exceeds 50%, then it would be green, so 62.09% would be green
For Orders Timeframe when he/she completes the order less than 60 it would be green, so 33 would be green...
So from rows 2 thru 19, only 2 goals were met...So I'd like a count of the green cells to see how goals were met (out of the 10 goals)
It would be 2 goals met (with both 62.09 & 33 being green cells)



[TABLE="width: 614"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]COLUMN B (TARGETS)[/TD]
[TD]COLUMN C (TARGETS AMOUNT -GOAL) [/TD]
[TD]COLUMN D (USER DATA)[/TD]
[/TR]
[TR]
[TD]ROW 2[/TD]
[TD]Discharge %[/TD]
[TD]50%[/TD]
[TD]62.09%[/TD]
[/TR]
[TR]
[TD]ROW 3[/TD]
[TD] [/TD]
[TD]Total Orders[/TD]
[TD]699[/TD]
[/TR]
[TR]
[TD]ROW 4[/TD]
[TD]Score[/TD]
[TD]84.47%[/TD]
[TD]75.40%[/TD]
[/TR]
[TR]
[TD]ROW 5[/TD]
[TD] [/TD]
[TD]Surveys[/TD]
[TD]57[/TD]
[/TR]
[TR]
[TD]ROW 6[/TD]
[TD]Records[/TD]
[TD]3[/TD]
[TD]58[/TD]
[/TR]
[TR]
[TD]ROW 7[/TD]
[TD]CPOE %[/TD]
[TD]90%[/TD]
[TD]88.73%[/TD]
[/TR]
[TR]
[TD]ROW 8[/TD]
[TD]Infections %[/TD]
[TD]70%[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]ROW 9[/TD]
[TD] [/TD]
[TD]Cases[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ROW 10[/TD]
[TD]Attendance[/TD]
[TD]80%[/TD]
[TD]71%[/TD]
[/TR]
[TR]
[TD]ROW 11[/TD]
[TD]Orders Timeframe[/TD]
[TD]60[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]ROW 12[/TD]
[TD]Rate[/TD]
[TD]75%[/TD]
[TD]55.49%[/TD]
[/TR]
[TR]
[TD]ROW 16[/TD]
[TD]Length of Stay[/TD]
[TD]1.40[/TD]
[TD]1.64[/TD]
[/TR]
[TR]
[TD]ROW 17[/TD]
[TD] [/TD]
[TD]Cases[/TD]
[TD]511[/TD]
[/TR]
[TR]
[TD]ROW 18[/TD]
[TD]Length of Stay[/TD]
[TD]5.00[/TD]
[TD]5.01[/TD]
[/TR]
[TR]
[TD]ROW 19[/TD]
[TD] [/TD]
[TD]Cases[/TD]
[TD]708[/TD]
[/TR]
</tbody>[/TABLE]

 

[Manny74]

Sorry I accidentally posted my response twice...