Count number of times cell filled in multiple sheets

[hellothere4]

Hello, I have 10X10 grid format, and I have a variable number of sheets of various names. I want the first sheet to tell me how many times each cell is used in the various sheets. So for example, if I had 3 sheets, and in sheet 2 and 3 cell [5,5] both had some text in them, sheet 1 [5,5] would have a value of 2. Not sure where to begin, so I hope someone can help, thank you.

 

[T. Valko]

Hello, I have 10X10 grid format, and I have a variable number of sheets of various names. I want the first sheet to tell me how many times each cell is used in the various sheets. So for example, if I had 3 sheets, and in sheet 2 and 3 cell [5,5] both had some text in them, sheet 1 [5,5] would have a value of 2. Not sure where to begin, so I hope someone can help, thank you.

One way...

Create a sheet "sandwich".

Insert a new sheet immediately to the left of the first sheet to be included in the calculation. Name this sheet Start.

Insert a new sheet immediately to the right of the last sheet to be included in the calculation. Name this sheet End.

It would look something like this:

\Summary/ \Start/ \Sheet1/ \Sheet2/ \Sheet3/ \End/

Then, to count how many of the sheets have an entry in cell A1...

Enter this formula on the Summary sheet:

=COUNTA(Start:End!A1)

If you want to include additional sheets in the future just place them betweent the Start sheet and the End sheet.