If there is a chance that the datalist might contain a blank cell, or that
you might have to delete an entry at a later time, you can try this, which
works with blanks, as well as text or numbers:

=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&""))
--

HTH,

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


"ChelleA" wrote in message
...
Myrna, you were also correct thanks again.

"Myrna Larson" wrote:

Assuming the data occupies A2:A100

=SUM(1/COUNTIF(A2:A100,A2:A100))

entered as an array formula with CTRL+SHIFT+ENTER.



On Thu, 17 Feb 2005 14:45:03 -0800, "ChelleA"
wrote:

I have a listing of proceedures for each patient. But I want to
summarize
the number of patients with out having to manually have to go in and
count.
Is there a formula, or function that can do this?
Example:
column A column B column C
Patient number Proceedure number proceedure date
4455 152 1/1/05
4455 188 1/1/05
4455 145 1/1/05

When you sum the column A it gives you a value of one for each occurance,
but I'd like to tell me the number of patients (1) at visited not number
of
proceedures (3).