Thread
:
sumProduct with OR condition
View Single Post
10-11-2019, 03:23 AM
p45cal
Windows 10
Office 2016
Expert
Join Date: Apr 2014
Posts: 871
perhaps:
=SUMPRODUCT((A1:A9000 <=E1)*(((B1:B9000 >=E1)+(B1:B9000 = ""))>0))
?
p45cal
View Public Profile
Find all posts by p45cal