Thread: I have a problem with these two formulas and a wild card
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
  
Posts: 304
Default I have a problem with these two formulas and a wild card
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))
Reply With QuoteReply With Quote