So you want a distinct count of all the accounts like

12345
12345
67891

would count as 2?

If so

=SUMPRODUCT(--(A1:A250<>""),1/COUNTIF(A1:A250,A1:A250&""))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"anniejhsu" <anniejhsu.28nl9m_1149047702.0583@excelforum-nospam.com> wrote
in message news:anniejhsu.28nl9m_1149047702.0583@excelforum-nospam.com...
>
> Thanks for the help. Unfortunately, there are hundreds of unique account
> ID numbers in this column, so using countif for each of them wouldn't
> work. Is there any way to determine this information without having to
> name the actual account ID in the formula?
>
> Thanks,
> Annie
>
>
> --
> anniejhsu
> ------------------------------------------------------------------------
> anniejhsu's Profile:
> http://www.excelforum.com/member.php...o&userid=34961
> View this thread: http://www.excelforum.com/showthread...hreadid=546966
>