Hello hello,

Im creating a monthly spreadsheet to track my teams performance and one of the metrics my department tracks scales with how many shifts they worked.

My goal was to use COUNTIF to simply count how many times each of their names pop up on each of the daily tabs and plug that into my formula.

The issue is that while their names will populate within the same range A2:A18 they may not be in the same places since some work different days than others. For example

09/01                 09/02
John                   John
Jane                   Sebastian
Sebastian

How can I set up the function to not only count through multiple sheets but also not give me an error if the value isnt exact just cause of the nature of the how the names are organized?

​Hello hello, Im creating a monthly spreadsheet to track my teams performance and one of the metrics my department tracks scales with how many shifts they worked. My goal was to use COUNTIF to simply count how many times each of their names pop up on each of the daily tabs and plug that into my formula. The issue is that while their names will populate within the same range A2:A18 they may not be in the same places since some work different days than others. For example09/01                 09/02John                   JohnJane                   SebastianSebastianHow can I set up the function to not only count through multiple sheets but also not give me an error if the value isnt exact just cause of the nature of the how the names are organized?  Read More

​