I have attached an example of a spreadsheet whereby I am trying to count the number of "x's" in Column B based upon the "department" in Column A. I have tried the Count, CountIf and CountIfs functions but cannot get it to work. Do I have to be concerned about how the cells are formatted? Can anyone provide with me a solution?
Example.xlsx
Bookmarks