I need to count how many times certain phrases come up from multiple
worksheets. Let me explain the problem more in detail. I have a worksheet for
every day and each day has about 8-20 names/ numbers listed (ex. 00515 - name
1, 00515 - name2, 65487- name 3). Instead of me going through each day and
counting how many times each one comes up, I was wondering if there is a way
to have a formula on the last page to count how many times each phrase is
lested from 31 worksheets. I have the list of all phrases on the 1st
worksheet that has about 90 differ names. Conclusion: Is there a way to say
look for whats listed in A1 on this worksheet and search all 31 worksheet
tabs and tell me how many times it comes up? Thank You