sumProduct with OR condition

Microsoft Office Forums

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

Reply

#1

Old

10-16-2019, 10:57 AM

p45cal

p45cal is offline

sumProduct with OR condition

Windows 10 sumProduct with OR condition

sumProduct with OR condition

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

p45cal has a reputation beyond repute

Default

try along the lines of:

Code:

=SUMPRODUCT((C2:C8<=G2)*((C2:C8<>""))*((D2:D8>=G2)+(D2:D8="")))

Reply With Quote

#2

Old

10-16-2019, 02:19 PM

ShostyFan

ShostyFan is offline

sumProduct with OR condition

Windows 10 sumProduct with OR condition

sumProduct with OR condition

Office 2007

Novice

sumProduct with OR condition

Join Date: Oct 2019

Posts: 4

ShostyFan is on a distinguished road

Default

Quote:

Originally Posted by p45cal

View Post

try along the lines of:

Code:

=SUMPRODUCT((C2:C8<=G2)*((C2:C8<>""))*((D2:D8>=G2)+(D2:D8="")))

works perfectly.
Thanks!

Reply With Quote

Reply

« 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 05:54 PM.