On 24 Jun 2005 11:10:30 -0700, "GregR" wrote:

The entry is stored as 05-45-000-000-000 and your formula works. I was
just musing, if it was a number, what adjustment would I have to make.
TIA

Greg

Depending on the length of your serial number, something like:

=SUMPRODUCT((INT(A1:A100/10^11)=5)*1)


--ron