All geek questions in one place

How to count wildcards using Excel COUNTIF?

How to count the number of cells containing the string "A *" without considering the star as a wildcard?

+3
source share
1 answer

Quoted directly from Excel reference documents: “If you want to find the actual question mark or asterisk, enter a tilde (~) before the character.”

COUNTIF (A1: A4, "A ~ *")

+9
source

Source: https://habr.com/ru/post/1716152/

More articles:


All Articles