As Dave noted, your col S could be/contain text numbers

Think you could try this pair which should work fine:

1.
=SUMPRODUCT((ISNUMBER(SEARCH("IMPORT",'All Divisions'!$U$2:$U$3321)))*'All
Divisions'!$S$2:$S$3321)

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

Replace SEARCH with FIND if you need it to be a stricter, case sensitive
search.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.

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

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