You have another response at your other thread.

If neither is what you need, you may want to restate your question.

delali wrote:
>
> Hi all,
>
> I need some kind of escape character in the criteria part of this function.
>
> example, =SUMPRODUCT((A4:A15=("January"))*(B4:B15="Monday")) should also
> count cells in B4:B15 where the cell contains both Monday and tuesday.
>
> something like =SUMPRODUCT((A4:A15=("January"))*(B4:B15="*Monday*")) but
> this doesn't work because the two ** around Monday are considered as part of
> the string being searched for. I need some kind of escape character to
> differentiate them from criteria, which is Monday.
>
> thanx in advance...

--

Dave Peterson