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

Thread: sumProduct with OR condition

View Single Post

Old

10-16-2019, 11:23 AM

CARACALLA

CARACALLA is offline

CARACALLA uses Windows 10

Windows 10 CARACALLA uses Office 2019

CARACALLA uses Office 2019

Office 2019

Novice

Join Date: Oct 2019

Posts: 1

CARACALLA is on a distinguished road

Default

G1=sumproduct(($c$2:$c$5>=g2)*(($d$2:$d$5<=g2)+($d $2:$d$5="")))

Reply With Quote