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

%3CLINGO-SUB%20id%3D%22lingo-sub-1655737%22%20slang%3D%22zh-CN%22%3EUrgent%20for%20the%20answer%3A%20How%20do%20I%20directly%20count%20the%20types%20after%20the%20screening%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655737%22%20slang%3D%22zh-CN%22%3E%3CP%3EHow%20do%20I%20directly%20count%20the%20types%20after%20the%20screening%3F%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%3ENO%20'sum(1%2Fc%3C%2FSPAN%3E%3CSPAN%3Eountif%20(B8%3AK9%2C%20B8%3AK9))'%20!!!!!!.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ecause%20we%20have%20an%20uncountable%20amount%20of%20data.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1655737%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1657190%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20for%20the%20answer%3AHow%20do%20I%20directly%20count%20the%20types%20after%20the%20screening%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F789762%22%20target%3D%22_blank%22%3E%40no_sloth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20exactly%20would%20you%20like%20to%20calculate%3F%20If%20number%20of%20unique%20values%20it%20works%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20645px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217752iB99A592CE4612982%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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