View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Wildcards in SUMIF Function

Using a SUMIF function, what wildcard could I use to sum only the CAD-ECs
($9,000)?
Obviously, €œCAD-EC-*€ doesnt work. Or does it, and I dont know how to use
it.

A B
CAD-EC-001 $4,000
CAD-GC-001 $1,000
CAD-PC-001 $1,000
CAD-EC-002 $5,000