How to use AVERAGEIFS for a date range

A

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top