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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls Help! 8
Formula error!! 4
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Counting the Unique Numbers 2
Countif and dates 3
Countif and dates??? 7
Counting sets of cells based on two parameters 4

Back
Top