cortexnotion
Board Regular
- Joined
- Jan 22, 2020
- Messages
- 150
- Office Version
- 2013
- Platform
- Windows
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!
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!
VBA Code:
=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))