i have 2 formulas to count entries from multiple pages into a totals page, one gives me an error?
i am counting how many times employee "A" has done a certain task in category "A" (30 days) on multiple sheets, and how many times employee "A" has done a certain task in category "B" (60 days). one formula works, the second formula works when the name is different, but not when the name is the one i need. it works with every other name I enter.
Help Article Resources
Check out the Formula Handbook template!