exl 2010 countif, criteria=final digit in string is not present in other characters

A bit of a roundabout way, but would the attached work?
The total number is listed in V2.

Try using this formula

=SUMPRODUCT((LEN(SUBSTITUTE(A1:F47,RIGHT(A1:F47),""))=5)+0)

That works specifically for your scenario where every cell has 6 characters. For variable character length you could make that

=SUMPRODUCT((LEN(SUBSTITUTE(A1:F47,RIGHT(A1:F47),""))=LEN(A1:F47)-1)+0)

both formulas give 162 with your example (I think Melvin's formula is counting those cells where the last character is repeated)

No problem,

Lets look at a single cell - imagine D3 contains 123456 - you want to ascertain whether the last character, 6, occurs anywhere else in that cell - you can get the last character using RIGHT function, i.e.

=RIGHT(D3) = "6"

Now if I use SUBSTITUTE to replace any 6 in D3 with a blank [""] then I can do that like this

=SUBSTITUTE(D3,RIGHT(D3),"")

so because that replaces all instances in D3 of RIGHT(D3) with a blank it converts 123456 to "12345"

Why is that useful? Because if the rightmost value only occurs once in D3 the resultant value will always have 5 characters, if 6 occurred anywhere else in D3 the result would be < 5 characters, e.g. if D3 was 123656 then =SUBSTITUTE(D3,RIGHT(D3),"") = "1235"

....so we can test the resultant cell length with LEN function, i.e.

=LEN(SUBSTITUTE(D3,RIGHT(D3),""))=5

Now that will return TRUE or FALSE depending on whether the last character in D3 repeats or not, we can make it 1 or 0 by doing this

=(LEN(SUBSTITUTE(D3,RIGHT(D3),""))=5)+0

Now, finally we can replace D3 with a range of cells, so

=(LEN(SUBSTITUTE(A1:F47,RIGHT(A1:F47),""))=5)+0

will return a 6x47 matrix of 1/0 values, so for your calculation we just need to sum those. SUM can be used like this

=SUM((LEN(SUBSTITUTE(A1:F47,RIGHT(A1:F47),""))=5)+0)

....but that formula needs to be confirmed with CTRL+SHIFT+ENTER so my preference is to use SUMPRODUCT in place of SUM to avoid "array entry" (although it only sums the values as before)