Forum Discussion
Can someone help me create the correct formula
Hi. I need help getting the formula correct. I need to count the number occurrences of blue, green, purple, and blank cells. Am I even using the right function? If the function is right, what am I en...
Use a combination of SUM and COUNTIF:
=SUM(COUNTIF(D2:D12, {"blue", "green", "purple"}))
If you also want to count blank cells in the range:
=SUM(COUNTIF(D2:D12, {"blue", "green", "purple", ""}))