Wildcard *

Glenn Chambers

Hello,

Needing to know if we can use Wildcards in a countif formula?

=COUNTIF({Copy of Projects Range 1}, HAS(@cell, "450-S*"))

Looking for formula to count every occurrence of a cell that 'starts with' 450-S

Thank you,

Glenn

Kelly Moore

Hey @Glenn Chambers

You might be able to use the CONTAINS formula. The HAS function looks for an exact match.

If you cannot use CONTAINS, try this

=COUNTIFS({Copy of Projects Range 1}, HAS(LEFT(@cell, 5), "450-S"))