|
|
#1
10-10-2019, 10:14 AM
|
|||
|
|||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sumproduct | arndts | Excel | 6 | 01-09-2019 01:10 AM |
 Countifs and Sumproduct
|
Algo | Excel | 6 | 11-13-2012 07:44 AM |
| sumproduct?? | jer | Excel | 9 | 10-14-2012 10:00 AM |
|
Sumproduct formula
|
Portucale | Excel | 2 | 09-12-2012 10:51 AM |
|
Sumproduct
|
angie.chang | Excel | 3 | 06-14-2012 10:00 AM |
Windows 10 
Office 2007
Threaded Mode