Discover latest Indian Blogs Excel Shortcuts - Count Text Skip to main content

Excel Shortcuts - Count Text

# Little Savings

If you want to count, no. of times the text has been repeated in a row, the following function will be helpful.

Function Name - COUNTIF(Range, "Text")

In the below example, based on the no of times, the Yes has been repeated, the ponts to be counted. So, the function "CountIf" will be useful.
Little Savings - Excel