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

Wildcards in SUMIF Function
 

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" 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

Wildcards in SUMIF Function
 

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

"ron" wrote:

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

Wildcards in SUMIF Function
 

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

Wildcards in SUMIF Function
 

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" wrote:

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" 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

Wildcards in SUMIF Function
 

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" wrote in message
...
Update:
"CAD-EC-*" actually works in a SUMIF function. It's a Conditional Sum
function that I need the wildacrd technique for.

"ron" wrote:

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

Wildcards in SUMIF Function
 

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

Wildcards in SUMIF Function
 

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

Wildcards in SUMIF Function
 

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.

"T. Valko" wrote:

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

Wildcards in SUMIF Function
 

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