Count Unique values - multiple criteria with an OR condition

[cortexnotion]

Hi All

I have the below formula working for counting unique values in column G with multiple criteria. I now need to increase the criteria in column L to 3 criteria. I have attempted the below but I clearly don't have the formatting right...

Many thanks!

=SUMPRODUCT((L3:L1000={"INITIAL SUBMISSION","TEMPLATE CREATION","DATA COLLECTION"})*(M3:M1000="OVERDUE"),1/COUNTIFS(L3:L1000,L3:L1000,M3:M1000,M3:M1000,G3:G1000,G3:G1000))

 

[jasonb75]

Any empty cells in any of those columns? Without test data, I don't remember if empty cells cause incorrect results or errors but I do remember them being a problem.

Also, it would depend on what type of 'unique' count you need. In this simple example, should the result be 1 or 2?

Book1
	A	B
1	Column G	Column L
2	a	Initial
3	a	Initial
4	a	Template
5	a	Template
Sheet1