Conditional Countif
 

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

Conditional Countif
 

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

Conditional Countif
 

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

Conditional Countif
 

Try this...

Names in column A, A2:A100.

Enter this formula in C2:

=CHAR(64+ROWS(C$2:C2))

Enter this formula in D2:

=COUNTIF(A$2:A$100,C2&"*")

Select both C2 and D2 and copy down to C27:D27

--
Biff
Microsoft Excel MVP


"Hope" wrote in message
...
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