I am using Office for Mac 2011 and am attempting to calculate a percentage of a document status as an employee performance metric. I am getting a consistent "That name is not valid" error message highlighting "[A2" for the following formula (relevant xls workbook attached):
=COUNTIFS(B2:B500, "47", [A2:A500, "Green"])/COUNTIF(B2:B500, "47")
Bookmarks