Thread: sumProduct with OR condition
View Single Post
 
Old 10-16-2019, 02:19 PM
ShostyFan ShostyFan is offline Windows 10 Office 2007
Novice
  
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