Thread
:
sumProduct with OR condition
View Single Post
10-16-2019, 10:57 AM
p45cal
Windows 10
Office 2019
Expert
Join Date: Apr 2014
Posts: 871
try along the lines of:
Code:
=SUMPRODUCT((C2:C8<=G2)*((C2:C8<>""))*((D2:D8>=G2)+(D2:D8="")))
p45cal
View Public Profile
Find all posts by p45cal