I ASKED THE FOLLOWING QUESTION YESTERDAY, AND RECEIVED A COMMENT THAT
APPEARED TO WORK. HOWEVER, THE CALCULATION IS COMING OUT WRONG. PLEASE
LOOK AND HELP ME.

Array Formula: =SUM(1/COUNTIF(A1:A4,A1:A4)*(B1:B4>250)) 

A           B
1	 $500.00 
2	 $500.00 
5	 $500.00 
2	 $100.00 
	
The result should be "3" (i.e. 3 unique records over $250), however it
is coming up as "2.5"

***********************************

Original Question:

I have a spreadsheet with columns that look like this: 

A B C 
Bob 555-1212 $250 
Joe 444-1212 $225 
Bob 555-1212 $250 

I need to get the number of UNIQUE records that are greater than $200. 

The COUNTIF function (i.e. COUNTIF(C1:C3,">200") returns "3" because it 
cannot distinguish between record data. However, since record 1 and 3 are 
identical (let's use the phone as the criteria), I only want it
counted once and have the returned calculation in the cell be "2".

What formula or array can first identify the criterion from Column C
(i.e. >$200) and only count the number of instances when the records
are unique
(based upon a second criteria, i.e. the data from Column B)? 

or in the converse, can first filter through all the phone numbers for
unique entries and then count the number of >$200 records from this
list?

THANKS!!

p.s. I am not interested in manually auto-filtering the
results. What I need is a formula (array or function) that will do all
of this for me.