Wildcards in SUMIF Function

[ron]

Using a SUMIF function, what wildcard could I use to sum only the CAD-EC’s
($9,000)?
Obviously, “CAD-EC-*†doesn’t work. Or does it, and I don’t 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

 

[Bob Phillips]

This works fine for me

=SUMIF(A:A,"CAD-EC*",B:B)

as long as B column are numbers.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ron]

Update:
"CAD-EC-*" actually works in a SUMIF function. It's a Conditional Sum
function that I need the wildacrd technique for.

 

[T. Valko]

Obviously, "CAD-EC-*" doesn't work. Or does it

Works for me:

=SUMIF(A1:A4,"CAD-EC-*",B1:B4)

Better if you use a cell to hold the criteria:

D1 = CAD-EC- or even CAD-EC

=SUMIF(A1:A4,D1&"*",B1:B4)

Biff

 

[ron]

Update:
"CAD-EC-*" actually works in a SUMIF function. It's a Conditional Sum
function that I need the wildacrd technique for. Sorry. And, yes, column B
is numbers only.

 

[Bob Phillips]

SUMIF is a conditional SUM function.

Are we missing something here?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ron]

I agree with what everyone is saying about this working with SUMIF funtion,
but when I use the Conditional Sum Wizard the * doesn't work for me.

 

[T. Valko]

I never use the conditional sum wizard. I've checked it out and it seems
that it is designed for more "complex" situations and produces array
formulas which aren't particularly efficient or even the best solution. But,
that's what you get from "wizards" (artificial intelligence)?

Biff

 

[ron]

Thanks. I rephrased the question this morning 2/13/07 with subject tilte
"Wildcard for Conditional Sum Wizard statement". If you'd like you can go
there and see the answer that worked for me.

 

[Bob Phillips]

artificial lack-of ...

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)