Actually once you get the hang of it they are very efficient albeit
clumsy to set up, they are also much faster than an array formula
if the data set is large. By learning them you'll also learn the
advanced filter which uses the same type of criteria


Peo Sjoblom

T. Valko wrote:
The "D" functions are "too confusing"!

Try this entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):

=AVERAGE(IF((A7:A13=A1)*(A7:A13<=A2),C7:C13))

The result is -3.98 not -3.83.

Format the cell in the negative style of your choice.

Biff

"JR Hester" wrote in message
...
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.