Urgent for the answer:How do I directly count the types after the screening ?

Copper Contributor

How do I directly count the types after the screening ?

 

NO  '=sum(1/countif(B8:K9,B8:K9))' !!!!!!

cause we have an uncountable amount of data

1 Reply

@no_sloth 

What exactly would you like to calculate? If number of unique values it works

image.png