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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!