Conditional Countif

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

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
 
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
 
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!
 
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
 
Back
Top