Count right digit

  • Thread starter Thread starter Cjer
  • Start date Start date
C

Cjer

Cell values in EX12:EX60 are "I" in some cells and "RI" in others.
I want to count how many cells have an "I" in it (including the "I" in the
"RI"'s) in the range EX12:EX60. I can count the "I" in "RI" in one cell
(EX60) only with this function:
=IF(RIGHT(EX60,1)="I",COUNTA(EX60),"").

However, I want to count the "I"'s in the whole range (EX12:EX60) I tried:
=IF(RIGHT(EX12:EX60,1)="I",COUNTA(EX12:EX60),"") and get errors.

Any suggestions?
 
=countif(ex12:ex60,"*I*")

Will count the number of cells that contain I (anywhere in the cell).
 
And if you really mean, the value has to end with an I:

=countif(ex12:ex60,"*i")
 
Back
Top