View Single Post
 
Old 10-10-2019, 10:14 AM
ShostyFan ShostyFan is offline Windows 10 Office 2007
Novice
 
Join Date: Oct 2019
Posts: 4
ShostyFan is on a distinguished road
Default 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?
Reply With Quote