Reply to thread

Message: [QUOTE="ron, post: 3689514"] 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. [/QUOTE]