Countif

[Puppies72]

Hi all,

I need a count of all the cells in A2:A10001 where the last digit is 1.

I've tried constructing the countif myself but to no joy can anyone help with this please, preferably without the use of hidden columns or anything, I can achieve the result that way myself but would prefer to do it in a single cell formulae

thanks

Puppies

 

[barry houdini]

Are the values integers? If so try using MOD function in SUMPRODUCT like this

SUMPRODUCT((MOD(A2:A10001,10)=1)+0)