![]() ![]() Also, this does not apply to boolean values. NOTE: Here, the asterisk symbol helps find cells with any sequence of leading or trailing characters. The formula =COUNTIF(C2: C12, “*HUBEI*”) counts the cells that have the value “HUBEI” in the range C2 to C12. If you want a partial match, you can use wildcard characters to count cells that contain a particular word or letters. The function =COUNTIF(D2: E12,”*”) executes over the range D2 to E12 and counts cells that contain text. In the following demo, you will see how the wildcard ‘*’ matches any number of characters. The ‘*’ or asterisk symbol helps find any number of characters.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |