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?