artificial lack-of ...

--
---
HTH

Bob

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



"T. Valko" wrote in message
...
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" wrote in message
...
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" wrote:

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" wrote in message
...
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