I am trying to use countif to count the number of times a unique items occurs in multiple worksheets.
For example, I want to count number of times "ITEM1" occurs in row 1 of sheets1, sheets2, sheets3, sheet4, etc. It may look like this:
Sheet1 = 4 entries
Sheet2 = 22 entries
Sheet3 = 5 entries
Sheet4 = 10 entries
So the entire count would be 41 total. Thanks.
Bookmarks