Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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.



This post first appeared on Little Savings, please read the originial post: here

Share the post

Excel Shortcuts - Count Text

×

Subscribe to Little Savings

Get updates delivered right to your inbox!

Thank you for your subscription

×