G
Guest
Hello,
Can someone please lend a hand with the correct syntax to do the
following?
I have a column of dates within a named range database table. I am
trying to setup the worksheet to allow my users to aggregate the daily
data into specified months. So for a simple example I would be using
"Table" as the named range for all columns, "Date" as the column with
daily dates, and "Data" as the column name of the data I want to
aggregate.
I assume it would be best to have a table off to the side that would
have the month numbers I need to aggregate and then have the Dsum
formula reference that table?
(criteria range)
Date
1
2
5
To aggregate months 1, 2, and 5)
Then Dsum(Table,"Data",criteria range)
I issue is how do I get the formula to look for months versus actual
dates? I suppose if I was doing a simple > or < it would be simpler,
but I need to allow ability to select non congruent months.
Thanks in advance for any insights on how to get this done!!
Greg
Can someone please lend a hand with the correct syntax to do the
following?
I have a column of dates within a named range database table. I am
trying to setup the worksheet to allow my users to aggregate the daily
data into specified months. So for a simple example I would be using
"Table" as the named range for all columns, "Date" as the column with
daily dates, and "Data" as the column name of the data I want to
aggregate.
I assume it would be best to have a table off to the side that would
have the month numbers I need to aggregate and then have the Dsum
formula reference that table?
(criteria range)
Date
1
2
5
To aggregate months 1, 2, and 5)
Then Dsum(Table,"Data",criteria range)
I issue is how do I get the formula to look for months versus actual
dates? I suppose if I was doing a simple > or < it would be simpler,
but I need to allow ability to select non congruent months.
Thanks in advance for any insights on how to get this done!!
Greg