R
ron
In a simple SUMIF function this
=SUMIF(A2:A5,"CAD-EC-*",B2:B5)
works fine for summing the two CAD-EC entries below ($9,000).
A B
CAD-EC-001 $4,000
CAD-GC-001 $1,000
CAD-PC-001 $1,000
CAD-EC-002 $5,000
But when I use the Conditional Sum Wizard,
=SUM(IF(A2:A5="CAD-EC-*",B2:B5,0))
This “CAD-EC-*†doesn’t work. Or does it, and I don’t know how to use
it. The reason I need to use the conditional sum wizard is that I actually
have other conditions, I'm just trying to keep it simple to find the correct
wildcard usage.
=SUMIF(A2:A5,"CAD-EC-*",B2:B5)
works fine for summing the two CAD-EC entries below ($9,000).
A B
CAD-EC-001 $4,000
CAD-GC-001 $1,000
CAD-PC-001 $1,000
CAD-EC-002 $5,000
But when I use the Conditional Sum Wizard,
=SUM(IF(A2:A5="CAD-EC-*",B2:B5,0))
This “CAD-EC-*†doesn’t work. Or does it, and I don’t know how to use
it. The reason I need to use the conditional sum wizard is that I actually
have other conditions, I'm just trying to keep it simple to find the correct
wildcard usage.