Your =sumif() formula should work ok.

Maybe the values in S2:S3321 aren't really numbers--maybe they are text that
look like numbers.

pgarcia wrote:

I need a wild card for "Import". List of data has "IMPORT BREAKBULK" and
"IMPORT BROKERAGE", Thanks

The following do not work correctly.

=SUMIF('All Divisions'!$U$2:$U$3321,"IMPORT*",'All Divisions'!$S$2:$S$3321)

=SUMPRODUCT(--('All Divisions'!$U$2:$U$3321="IMPORT*"),--('All
Divisions'!$J$2:$J$3321=30),--('All Divisions'!$S$2:$S$3321))

--

Dave Peterson