special case of sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
You have another response at your other thread.

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