Count Unique Text Values in a Range with multiple criteria

[cesarmontesinos312]

How to Count Unique Text Values in a Range with multiple criteria (more than 3 to be precise) in Excel

[#2]

Hi @cesarmontesinos312 

You can use the function 

=COUNTA(UNIQUE(Range))

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer.

[#4]

Can I add 3 criteria? @Faraz Shaikh 

[#5]

Hi @cesarmontesinos312 

Please attach the sample file with your desired result

Regards, Faraz Shaikh

[#6]

Please see attached file@Faraz Shaikh