I want to keep one cell that houses the count of the data depending on how it
is filtered and that cell remain visible despite how it is filtered. I can't
get the formula =COUNT(C9,C1:C100) to work or get it to stay visible if I
change the filter.