Another option is to use a pivot table to summarize the data. You could
view the results by name or group the dates to show a specific year or
month. There are pivot table instructions and links he

http://www.contextures.com/xlPivot01.html


JR Hester wrote:
I am attempting to use Dsum and Daverage with a date range. Below is sample
of the data I have defined ranges named CRITERION as A1:c3, Variances as
A6:C13. My formula is =Daverage(Variances, 3, Criterion). This works for
individuals in name column, but not for the date values I have entered here.
Trying to get all March entries,
#1. can you show me the error of my way?
#2 Is it possible to use actual cell references instead of named ranges to
define the criterion data?

A B C
1 Date Name Variance
2 =3/01/06
3 <=3/31/06
4
5
6 Date Name Variance
7 3/15/06 Fred $(12.23) Subtotal $(26.82)
8 4/12/06 Julie $15.85 Average $(3.83)
9 3/18/06 Poncho $3.35 Count 7
10 5/10/06 Fred $(31.90)
11 3/30/06 Julie $(19.85)
12 3/10/06 Allie $12.81
13 4/12/06 Fred $5.15

Thanks for your suggestions.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html