| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions | |||
| Problems with SUMIF function and Wildcards (* and ?) | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
