special case of sumproduct

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" <delali@discussions.microsoft.com> a écrit dans le message de
news:13B4776F-BC0F-438C-A5E7-55435D21D055@microsoft.com...
> 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