Excel Hack 49: Three things you can do with the COUNTIF function in Excel
There are several ways you can use the COUNTIF() function in Excel. This post showcases three (3) possible applications involving the use of wildcards (see more on wildcards here) Count the number of cells with a known number of characters – e.g cells containing only three-letter words – in a range =COUNTIF(datarange, “???”) 2. Count