I have some data that is for different stores. The data is in the same format/same cells but it is in 10 worksheets, each for a different store.

The cells in the 10 worksheets have either a Y or an N or they are blank. What I would like in a summary sheet is to count the total of N and Y and the blanks. So I would like the computer to check for e.g cell C5 in all the 10 sheets and come back with a total of for e.g 6 Y, 2 N and 2 blanks.

I do not know if its possible toget the answer in 1 sheet. However if that is not possible it would still be OK if I could get the answer in 3 sheets. One sheet totalling the no of Y, the other N and the third counting the no of blanks.

Thanks