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,