View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?