Microsoft Office Tutorials and References
In Depth Information
Figure 26-5: Examples of the SPELLDOLLARS function.
The SPELLDOLLARS function is too lengthy to list here, but you can view the complete
listing in spelldollars function.xlsm at this topic's website.
Chapter 7 contains many formula examples to count cells based on various criteria. If you can't arrive at a
formula-based solution for a counting problem, then you can probably create a custom function. This section
contains three functions that perform counting.
This topic's website contains the workbook counting functions.xlsm that demonstrates
the functions in this section.
Counting pattern-matched cells
The COUNTIF function accepts limited wildcard characters in its criteria: the question mark and the asterisk, to
be specific. If you need more robust pattern matching, you can use the LIKE operator in a custom function.
Function COUNTLIKE(rng As Range, pattern As String) As Long
Count the cells in a range that match a pattern