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...