Hi all. Is it possible to use a disjoint range for the criteria parameter of
the DSUM function?
I have a worksheet tab (called Data) that contains my list. It looks like
the following:
Year Name Value Region
----- ------- ------ ---------
2001 Revenue 10 East
2001 Expense 20 East
2002 Revenue 30 West
2003 Expense 40 North
....

I have worksheets for each region (East, West, North, South) which have a
cross tab that looks like:
2001 2002 ...
Revenue
Expense
....

I have a criteria range set up for each year on the same row that repeats
all the same values except for the Year...
L M N O P Q
R S T
--- --- --- --- --- ---
--- --- ---
Year Name Region Year Name Region Year
Name Region
2001 Revenue East 2002 Revenue East 2003
Revenue East
Year Name Region Year Name Region Year
Name Region
2001 Expense East 2002 Expense East 2003
Expense East


The crosstab table has DSUM formulas as follows:
2001 2002
...
Revenue dsum(Data,Value,L1:N2) dsum(Data,Value,O1:Q2) ...
Expense dsum(Data,Value,L3:N4) dsum(Data,Value,O3:Q4) ...
....

I would like to be able to reduce the repeating information by having
something like:
L M N O P
--- --- --- --- ---
Year Year Year Name Region
2001 2002 2003 Revenue East

and having my criteria look like:

2001 2002
...
Revenue dsum(Data,Value,(L1:L2,O1:P2)) dsum(Data,Value,(M1:M2,O1:P2))
....
....

Is this possible?

Thanks in advance.