I have a chart that tracks visitations and assessments. Currently, I will put an "A" or "V" in the cell, and the spreadsheet will count how many "A"s and how many "V"s are completed each month using the formulas =COUNTIF(C4:C142,"A") OR =COUNTIF(C4:C142,"V").
However, sometimes a visit AND assessment occur each month, requiring me to put a combination like VA, AVV or VVAV in a single cell. I want the spreadsheet to still be able to count how many "V"s and "A"s occur each month even if this sort of a combination existed in a single cell. Can anyone provide me with an answer?
Thanks!
Bookmarks