You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"PEGWINN" wrote in message
...
I would bet a weeks pay that I tried that formula or a very close varient
of
it last night before posting the question. When I noticed your answer I
was
working on a "count unique occurances" formula that would have subtracted
them from the total numbers. Ugly, Clunky, etc. Thank you very much for
saving my workbook from ugly and clunky.

-- Phil

"T. Valko" wrote:

Ok, so which range do you want to count against? A1:A6 or B1:B6?

This will count matches in A1:A6 that appear in B1:B6 :

=SUMPRODUCT(COUNTIF(B1:B6,A1:A6))

If I have it backwards just flip the ranges.


--
Biff
Microsoft Excel MVP


"PEGWINN" wrote in message
...
Ok,

a1:a6 are input. Six numbers (1,2,3,4,5,6)

b1:b6 is input from another range. (1,7,9,15,17,21,34,67,89)

I need to count the matches. The obvious answer is 1 in this example.

It's on the tip of my brain, teetering, just waiting to fall into
place.

"T. Valko" wrote:

Don't count based on formatting. Count based on: "matching an input
value."

But, we'd need the details!

--
Biff
Microsoft Excel MVP


"PEGWINN" wrote in message
...
Hi. I must have missed a function somewhere. I have a range of
numbers
that
have conditional formatting based on matching an input value. What I
would
like to do is count the cells that are conditionally formatted. I
tried
the
count functions but cannot find an argument to identify formatting
differences. TIA -- Phil