Summing instances of text across worksheets

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hello, I have a workbook with separate sheets for each month. The sheets
contain a list client names (entered exactly the same on each sheet). I need
to summarize how many times a client name appears in total. For example, John
Brown may appear Jan & Feb (=2) where Mary Brown may appear Jul, Sep, Dec
(=3).

I've been trying pivot tables without luck. Hoping someone can help.

Thanks in advance!
 
Never mind, I consolidated all the worksheet data into one and the pivot
table works fine.

Thanks anwyay!
 
Back
Top