Seems Simple But I Cant Get It !

  • Thread starter Thread starter cjjoo
  • Start date Start date
C

cjjoo

THIS IS MY PROBLEM:

i got a row with alpha_num entries(e.g RN1, P2, EN4)

i wan to count the number of entries that has the number 1 behind the
first two

alphabet.
 
Slight modification of Biff's formula should do it, after you
substitute your own range:

=SUMPRODUCT(--(RIGHT(A1:F1,1)="1"))

- DH
 
Back
Top