I've got the following table that I'm using to perform DSUM and DCOUNT calcs:
Can I set my sheet up so that when "-Central Division-" is selected by the user, the DSUM actually calculates the underlying regions in the Central Division? I basically want to add the market values for Great Lakes, Mid Central, Mid South, etc. but want to keep my sheet so the user (and underlying table) only look at one row when filtering. I'd prefer not to have to list each of the 5 regions to perform this calc.
THanks,
Mike
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | |||
4 | Region | CurrentRegionSelected: | ||||||||||
5 | -CentralDivision- | -CentralDivision- | ||||||||||
6 | GreatLakes | |||||||||||
7 | MidCentral | Example1--Wanttoperformcalcsonallregionswithinselecteddivision | ||||||||||
8 | MidSouth | RegionName | TransactionType | DateApproved | DateApproved | DCOUNT | DSUM | DSUMShares | ||||
9 | NorthCentral | -CentralDivision- | Sale | >=1/1/2005 | <=12/31/2005 | 0 | $- | 0 | ||||
10 | Southwest | |||||||||||
Sheet2 |
Can I set my sheet up so that when "-Central Division-" is selected by the user, the DSUM actually calculates the underlying regions in the Central Division? I basically want to add the market values for Great Lakes, Mid Central, Mid South, etc. but want to keep my sheet so the user (and underlying table) only look at one row when filtering. I'd prefer not to have to list each of the 5 regions to perform this calc.
THanks,
Mike