Keeping bang your head against a brick wall, you will be a talent.
Home
▼
Thursday, 4 August 2011
Excel_How to count text or multiple text
Count text formular: COUNTIF(P6:P20,"TEXT")
Count different text formular: SUMPRODUCT((P6:P20="TEXTA")+(P6:P20="TEXTB"))
Count any letter formular: COUNTIF(P6:P20,"*")
No comments:
Post a Comment