Pete,
I would like to count the number of times a, b, c etc appears as the first
letter in a specific column. Basically, I have a report where a column
contains the last name, first name of our clients. We work on an alpha split
for our service people. I'd like to use a formula or pivot table to count
the number of clients in each letter of the alphabet. Can this be done, and
if so how. Thanks in advance!

"Pete_UK" wrote:

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