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
|