Excel: Count the Colored Cells in each column (seperate Count for Green and Red)

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

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of June 21, 2017.

For more resources for Microsoft Excel