Count unique values for rows meeting specific criteria?

[glugs]

Been going around in circles with this for a while.. part way there, but
not completely..

I need to COUNT the number of UNIQUE values in Column A, but only count
rows if columns Q and R meet a certain criteria.

I have used this formula for the total unique values:

=(SUM(IF(FREQUENCY($A$2:$A$5507,$A$2:$A$5507)>0,1)))

Now I would like to know if I can use this formula, or if I need to use
something else to get my answer.

The two criteria I need to be met before the row can be included in the
unique value calculation are:

($Q$2:$Q$5507>=DATE(1998,6,31))

AND

($R$2:$R$5507<=DATE(1999,7,1)))

So to summarise:

All rows that meet these two date criteria's would result in a list of
rows that have duplicate numbers in column A.

So.. I need to then count the number of unique values that occur in
Column A, but only count values that are in rows which meet the two
date criteria.

I know it must be possible - and I've seen different unique value
calc's to the one above, but I just can't put the whole thing together.
I thought I could sumproduct the two date criteria against the unique
value sum, but it didn't work

Thanks!

 

[glugs]

any ideas anyone

 

[glugs]

does anyone know how to do this or a way around this problem!

 

[Cesar Zapata]

use

=countif(A1:A50,"hello")

you can use the sumif the same way





Cesar Zapata

 

[glugs]

Cesar,

I can't use countif if because it cannot meet more than one criteria.
I actually need to specify 3 criteria before the range is counted.

1. It is above a certain date in one column
2. It is below a certain date in a second column
3. It's value in the column I am counting is unique.

So it would read some thing

If Column Q is greater than B and Column R is less than C, then, coun
unique values in column A.

Anyone else have any suggestions