Hello All,
I'm looking for a formula to count the amount of Green Cells and Red cells in a given column. Under my grand total I want the count for Green cells for the column and under the Green cell count I want the red cell count.
Essentially, it would look like this:
Grand Total:20
Green (Pass):6
Red(Fail):2
Thanks
I'm looking for a formula to count the amount of Green Cells and Red cells in a given column. Under my grand total I want the count for Green cells for the column and under the Green cell count I want the red cell count.
Essentially, it would look like this:
Grand Total:20
Green (Pass):6
Red(Fail):2
Thanks