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

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

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