View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glempy Glempy is offline
external usenet poster
 
Posts: 1
Default Unique Names w/ Conditions

Your help would be GREATLY appreciated.

Here is an example of my spreadsheet:

Name Seen Called Cancelled
Fred *
Kathy *
Shelly *
Kim *
Kathy *
Fred *
Shelly *
Fred *
Kim *
Kathy *

Asterisks are used to indicate the status of each client (Name).
I need a formula (for example) that will tell me how many "Seen"
clients I have (not the # of times they were seen). In this case, the
result would be 4.

Thanks SO much.