How to count if cell contains text or part of text in Excel

Supposing you have a data range, and want to count the number of cells which contain the text "Apple", number of cells contain the text "Orange" and cells contain "Peach" separately, how to get it done? In this vedio, we explain the COUNTIF function in detail to help you quickly count the number of cells if they contain text or part of specific text in Excel. Besides, we introduce an awesome feature to acheive it easily with only clicks. You can follow the step-by-step guide via the following hyperlink: https://www.extendoffice.com/document...