How to use AVERAGEIFS for a date range

[Ahreum]

Hi:

=AVERAGEIFS(M1:M10,I1:I10,"Y",N1:N10,"Email",H1:H10,"<="&DATE(2010,3,31),H1:H10,"<"&DATE(2010,3,1))

--OR--

=AVERAGEIFS(M1:M10,I1:I10,"Y",N1:N10,"Email",H1:H10,
("<"&DATE(2010,3,1)&"<="&DATE(2010,3,31)))

Above is the equation that I'm having trouble with. Basically, I'm
trying to average Col M, if other fields in the record match the
following criteria:

Col I = "Y"
Col N = "Email"
Col H = Between 3/1/2010 and 3/31/2010

Unfortunately, I keep getting a #DIV/0! or #Value error. Can you
please help me?


Thank you!

 

[Clif McIrvin]

Hi:

=AVERAGEIFS(M1:M10,I1:I10,"Y",N1:N10,"Email",H1:H10,"<="&DATE(2010,3,31),H1:H10,"<"&DATE(2010,3,1))

--OR--

=AVERAGEIFS(M1:M10,I1:I10,"Y",N1:N10,"Email",H1:H10,
("<"&DATE(2010,3,1)&"<="&DATE(2010,3,31)))

Above is the equation that I'm having trouble with. Basically, I'm
trying to average Col M, if other fields in the record match the
following criteria:

Col I = "Y"
Col N = "Email"
Col H = Between 3/1/2010 and 3/31/2010

Unfortunately, I keep getting a #DIV/0! or #Value error. Can you
please help me?


Thank you!

Try changing your

,"<"&DATE(2010,3,1)

to

,">="&DATE(2010,3,1)

and see if that helps.

 

[sreekantorama]

You can try the following:

=AVERAGEIFS(M1:M10,I1:I10,"Y",N1:N10,"Email",H1:H10,">"&DATE(2010,3,1),H1:H10,"<="&DATE(2010,31,3))