Hi Terry,

Assuming you data start on row 2 and you have headings on row 1, with the
number 'count' headings starting in E1, try:
=SUM(IF(MOD($A2:$D2,10)=E$1,1,))
as an array formula in E2, copied down/across as far as needed.

FWIW, array formulae are input with <Ctrl-Shift-Enter, instead of just
<Enter

Cheers

--
macropod
[MVP - Microsoft Word]


"Terry M" wrote in message
...
I have numbers in columns labeled a through d. I would like to be able to
count the last digits in the numbers. Any ideas would be greatly
appreciated.

A B C D 1 2 3 4 5
6
93 86 21 83 2
1


Terry