countif

[Charles Woll]

I have a list of about 1000 numbers in column A of six digit numbers. I
wish to count only the numbers that end in "1".
i.e. 105001.
I have named the list in coulumn A "table".
Pls help...

--
\\\|///
\\ ~ ~ //
( @ @ )
--oOOo-(_)-oOOo---
Charlie Woll

 

[Dave Peterson]

=SUMPRODUCT(--(MOD(A1:A1000,10)=1))

would be one way

 

[Bob Phillips]

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

 

[RagDyer]

Try this:

=SUMPRODUCT(--(RIGHT(A1:A1000)="1"))
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Bernard Liengme]

This seems to work (limited testing)
=SUMPRODUCT(--(table-(INT(table/10)*10)=1))
best wishes

 

[Charles Woll]

Thank you for the promp solution.
charlie woll

=SUMPRODUCT(--(MOD(A1:A1000,10)=1))

would be one way