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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

special case of sumif 4
Sumproduct in matrix means 3
put data from cells into other cells 3
Counting Days of Week in Date Ranges 1
Cell Range Split into Multiple Cells 3
Comparison of columns using Conditional Formatting 3
Getting the sum of Column B when Column A is January 2
Case Sensitive Counting & Filtering 1

Back
Top