=SUMPRODUCT((A4:A15=("January"))*((B4:B15="Monday" )+(B4:B15="Tuesday")))

HTH
--
AP

"delali" a écrit dans le message de
...
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...