Forum Discussion
Solved
Need Help
Hi all expertise, I need your help as I have a excel problem. I would like to count the job number (unique) under the following criteria. Job Type = A Payment = Cash Answer should be 2 as Job nu...
Hi HansVogelaar,
Thank you so much, you helped me to fix this issue. Thanks
It should be
=COUNT(UNIQUE(FILTER(A:A, (B:B=E2)*(C:C=F2))))
Hi HansVogelaar,
Thank you so much, you helped me to fix this issue. Thanks