sumProduct with OR condition
Here is my formula:
=SUMPRODUCT((A1:C90000 <=E1)*(B1:B90000 >=E1)*(B1:B90000 <> ""))
It does not return the correct results, what I want it do is this:
=SUMPRODUCT((A1:A90000 <=E1)*(B1:B90000 >=E1 OR isNULL))
How do I make excel like what I am trying to tell it?
|