View Single Post
 
Old 08-23-2017, 10:14 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Probably not with SUMIF, but it can be done with SUMPRODUCT.

e.g.

=SUMPRODUCT(--(ISNUMBER(MATCH("*"&$C$1:$C$5&"*",A1,0))),$D$1:$D$ 5)

Where A1 is the cell containing the 5 states, and C1:C5 is the list you want to look in to find the matches and sum the adjacent cells D1: D5.

Warning... with Sumproduct it is advisable to not use full column ranges as this function is more processor intensive.
Reply With Quote