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.....
<tbody>
</tbody>
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>
Last edited: