I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the count is not rendering the correct results. I am using this formula for the Overall Health functions -
=COUNTIF([Overall Health]:[Overall Health], "Yellow")
Any assistance on what I am doing wrong is appreciated!