On Mon, 3 Sep 2007 18:26:14 +0100, "Sandy Mann"
wrote:

One way:

With the string that you are looking for in D1 try:

=SUM(LEN(A1:A1000)-LEN(SUBSTITUTE(LOWER(A1:A1000),D1,"")))/LEN(D1)

Array entered with Ctrl + Shift + Enter


How does that work with wildcards? e.g. a?e for mAdE as the OP requested?
--ron