Hi all,

I have a formula that calculates the amount of times the word appears on a sheet but now my problem is to include different sheets to get the total. My Sheets are renamed.

Basically i have a main data sheet and the rest of the sheets are various names with data on but i need to see how many times that word/text is used. Not sure if i have to name the sheets also to show in the Name Box?

My formula i have is as follows:

=COUNTIF(A1:A1000,A2)

I need to include say for example the following sheet names so it adds it all together :

Week Days
Month
Days

I have a formula I found on excel-easy.com but it give me an error:

=COUNTIF(Days!A1:A1000,D2)+COUNTIF(Month!A2:A6,D2)+COUNTIF(Week Days!A2:A6,D2)

Thanks in advance for any help