Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
Hi, I have a table with dsum formulas in each cell that recalculates every
time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
If you leave the criteria field blank it will calc all.
"jeq214" wrote: Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
="=*"
Or if the cost centers looks like Cost Center1 Cost Center2 etc ="=Cost Center*" -- Regards, Peo Sjoblom "jeq214" wrote in message ... Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
Well, the problem is, I have a range of cells for the criteria:
Cost Center | Date | Fee Type So is there a way to show all cost centers, but have a specific date and fee type? Thank you for your response. Jon "Jim" wrote: If you leave the criteria field blank it will calc all. "jeq214" wrote: Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
Sure. Leave the cost center criteria blank. Or, don't include the cost
center field in the criteria at all. Either way will work. "jeq214" wrote: Well, the problem is, I have a range of cells for the criteria: Cost Center | Date | Fee Type So is there a way to show all cost centers, but have a specific date and fee type? Thank you for your response. Jon "Jim" wrote: If you leave the criteria field blank it will calc all. "jeq214" wrote: Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
It didn't work. Is it because I have multiple criteria? I reference the
criteria to a range of cells which have Cost Center, Date and Fee Type. I need specific dates and fee types, but would like all cost centers. Thanks for your help Jon "Peo Sjoblom" wrote: ="=*" Or if the cost centers looks like Cost Center1 Cost Center2 etc ="=Cost Center*" -- Regards, Peo Sjoblom "jeq214" wrote in message ... Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
It doesn't matter how many criteria you have, it works fine if I test it
with some random dates, fee types and use multiple criteria -- Regards, Peo Sjoblom "jeq214" wrote in message ... It didn't work. Is it because I have multiple criteria? I reference the criteria to a range of cells which have Cost Center, Date and Fee Type. I need specific dates and fee types, but would like all cost centers. Thanks for your help Jon "Peo Sjoblom" wrote: ="=*" Or if the cost centers looks like Cost Center1 Cost Center2 etc ="=Cost Center*" -- Regards, Peo Sjoblom "jeq214" wrote in message ... Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for dsum formula
How did you get that to work? This is what I did:
Ex. of one formula in the table: =DSUM(DB,7,Reference!K14:M15) Reference!K14:M15 fee_Cost_Center fee_Date_Accepted fee_Fee_Type =ThisCC Jan-07 OD When i select ="=*" from the drop down, this is what the fee_Cost_Center looks like: fee_Cost_Center fee_Date_Accepted fee_Fee_Type =* Jan-07 OD but the values still come out $0 Am I missing something? Jon "Peo Sjoblom" wrote: It doesn't matter how many criteria you have, it works fine if I test it with some random dates, fee types and use multiple criteria -- Regards, Peo Sjoblom "jeq214" wrote in message ... It didn't work. Is it because I have multiple criteria? I reference the criteria to a range of cells which have Cost Center, Date and Fee Type. I need specific dates and fee types, but would like all cost centers. Thanks for your help Jon "Peo Sjoblom" wrote: ="=*" Or if the cost centers looks like Cost Center1 Cost Center2 etc ="=Cost Center*" -- Regards, Peo Sjoblom "jeq214" wrote in message ... Hi, I have a table with dsum formulas in each cell that recalculates every time the user selects a different Cost Center from a drop down list. Is there a wildcard char i can use to represent all cost centers so it can calculate all values for all cost centers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Criteria field in dsum formula | Excel Worksheet Functions | |||
Formula similar to DSUM | Excel Discussion (Misc queries) | |||
How do I use a wildcard in an excel formula? | Excel Worksheet Functions | |||
wildcard in formula vlookup | Excel Discussion (Misc queries) | |||
Wildcard IF formula | Excel Worksheet Functions |