I am attempting to do the same type of function. i have 16 worksheets (17 in the entire book, the first sheet is wehre i want the function, not where i want to pull information) from which i want to count a certain value. The value is located in B4 of each sheet and each sheet has a unique name. I simply want to count the number of times "Yes" appears across each of my worksheets on my first sheet titled "Dashboard".