Hi ,

Basically I have created a spreadsheet with details of several different people for HR purposes. Each person is assigned to a worksheet called 'People Info' and I have 70 copies of that worksheet with each persons details on. One of the criteria is each persons work status which has a drop down list with the words: Permanent, FTC, Apprentices etc.

I also have a sheet called 'Summary' with the headings : Permanent, FTC, Apprentices, etc. Which i am using to count the totals of how many Permanent/ FTC/Apprentice staff there are altogether.

Basically I am trying to create a formula for the 'Summary' sheet which counts how many times the word Permanent/FTC/Apprentice appears altogether, but this needs to count across worksheets. The data is on the same cell (A11) in each of the worksheets but I just cant work the formula out, can anyone help?

Cheers