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: