special case of sumproduct

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[Dave Peterson]

You have another response at your other thread.

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