You will need to put a formula like this in each sheet:

=COUNTIF(A:G,"*c*")

Suppose you put this in M1 of each sheet. Then in your main sheet you
could have this formula to add them all together:

=SUM(first:last!M1)

where first is the name of the first (left-most) sheet and last is the
final (right-most) sheet.

Hope this helps.

Pete

On Sep 24, 11:01*pm, Curtis wrote:
I need to count the number of times the letter c appears in multiple
spreadsheets in the same workbook

for example

sheet 1406 row 256 colum b = c
sheet 1491 same column row

there are about 23 different sheets

thanks