Sppidsolution
Keeping bang your head against a brick wall, you will be a talent.
Home
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,"*")
Fomular input method: Ctrl+Shift+Enter
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment