Shamima, thank you for your reply. I learned quite a bit from your example. I made your recommended changes, but when I execute the function, I get a #VALUE error. I'm not understanding how to correct that error. All help is appreciated.
Keith
I have aworkbook with multiple worksheets. I have various date data in Column C. On the first workshhet, I have a list of years (2022,2023,2024,etc) I want to count the total number of times a particular year (based on the year in a cell in the first sheet) across all worksheets. And I want to...
