sumProduct with OR condition

		Microsoft Office Forums > Microsoft Excel > Excel
sumProduct with OR condition

FAQ

Thread Tools

Display Modes

10-10-2019, 10:14 AM

ShostyFan

Windows 10 sumProduct with OR condition

Office 2007

Novice

Join Date: Oct 2019

Posts: 4

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 PM.