In column C, there are drop down values for Complete, Incomplete, and In Progress. I would like to put summary statements that say:
The TOTAL number of Complete: and show the sum of the Completes from column C.
What is the formula? There is only one column range of text.