Hi Patrick,

I came across this note in Excel help when I was looking for a different
"unique" problem. Why don't you pop "Count unique values among duplicates"
into help and look at the help item with that name. It talks to summing
cells with difined values. I expect that it would span an entire workbook.

Sorry, but I didn't look to see if it would do what you wanted, partially
because I don't think I fully understand the issue.

Hope it helps.
--
Bill Wehrmacher


"Steven Patrick" wrote:

I have started a workbook with each page being a month. On each page, each
column being a day. Each column has identifiers (labels) being a sub-catagory
by service type purchased for each unique customer.

I would like to (so far, I found the <cntr F) identify visit frequency by
customer, date and service type without creating the left to right access
type database. The find screen can identify month, day, with frequency, but
not service type (I thought - naming the range) due to syntax error or
physical impossibility of that function.

If this has already been discussed, I missed the topic, but would appreciate
the link.