search multiple items in sumproduct

[kmrowlan]

Is there a way to search for mutliple items in the formula below (ie. Distribution - TX, Distribution - VA, etc.)?

=SUMPRODUCT(
'Credit DATA'!$G$2:$G$3223,
--('Credit DATA'!$H$2:$H$3223 = "Distribution - TX"),
--('Credit DATA'!$L$2:$L$3223 >= $A$3),
--('Credit DATA'!$L$2:$L$3223 < $A$4))

 

[texasalynn]

try this
=SUMPRODUCT(
'Credit DATA'!$G$2:$G$3223,
--(LEFT('Credit DATA'!$H$2:$H$3223,12) = "Distribution"),
--('Credit DATA'!$L$2:$L$3223 >= $A$3),
--('Credit DATA'!$L$2:$L$3223 < $A$4))

note: untested