Microsoft Office Forums - View Single Post - sumProduct with OR condition

Thread: sumProduct with OR condition

View Single Post

Old

10-14-2019, 08:07 AM

ShostyFan

ShostyFan is offline

ShostyFan uses Windows 10

Windows 10 ShostyFan uses Office 2007

ShostyFan uses Office 2007

Office 2007

Novice

The original poster

Join Date: Oct 2019

Posts: 4

ShostyFan is on a distinguished road

Default

Quote:

Originally Posted by p45cal

View Post

perhaps:
=SUMPRODUCT((A1:A9000 <=E1)*(((B1:B9000 >=E1)+(B1:B9000 = ""))>0))
?

Thanks for the idea, but sadly it does not work either, adding the greater then 0 to the end gives me a result of 0 when there is desired data to be counted.

Reply With Quote