Thanks to you both, made all the difference in the world, adding a second
"date' column in my criteria. I get tunnel vision sometimes and need someone
to strike a match so I see my way out. Great service you performn here!

"Peo Sjoblom" wrote:

Use this criteria

Date Date Name Variance
="=3/01/06" ="<=3/31/6"


then I used this formula

=DAVERAGE(Variances, "Variance", A1:B2)

if you want to use 2 input cells (start date in E1 and end date in F1)
and put the dates there you can use

Date Date Name Variance
="="&E1 ="="&E1

it will return the date serial number in the cells which looks a bit
strange

=38777 and <=38807

anyway, that will work fine


Regards,

Peo Sjoblom




JR Hester wrote:
Thanks to each of you for your ideas, comments and recommendations. I would
agree that a pivot table might be a better fit in that instance. I am trying
to understand the "D" functions, however. I have succeeded in getting a
successful response with single criterion and even with "AND" criteria. That
is when the AND is two separate fields. What I am still having trouble
entering is a "RANGE" of criteria, such as all entries between, say 10/1/06
and 10/31/06. Of course in Access I simply enter = 10/1/06 and <=10/31/06 in
a criteria, but I have not found how to do this in the Excel criterion cells.
Any suggestions? Again I am trying to understand these D functions and their
use.

Thanks

"Debra Dalgleish" wrote:

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