Counting unique records with additional criteria

M

mike.wilson8

I have a list of unique records in a spreadsheet. Each record has a
value of either "open" or "closed". I can get the total number of
unique records by doing a = SUBTOTAL(3,A2:A999), however I need a
similar formula that can count the number of unique records + count the
number of records either with an "open" or "closed" status (all in one
entry). Ex - = SUBTOTAL(3,A2:A999, ="OPEN")

Any ideas?

Thanks,
 
D

Domenic

Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A999,ROW(A2:A999)-ROW(A2),0,1)),--(A2:A9
99="Open"))

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting unique instances of a text string 2
Counting unique values based on 2 columns 3
Trying to count based on multiple criteria & cell comparisons 4
Counting 3
Count unique with multiple criteria 3
Conditional count if question 4
Filtering Duplicate Data to obtain Unique record 8
count unique values in a filtered range 2

Top