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

Similar Threads

Use Scrollbar to create dynamic sum for a range of cells on Multi 0
How to sum when the criteria and the range are in the same row? 2
Knowledge gained from Access to Excel VBA Automation User request 0
Use ADO to add or update date in Access 10
Nested Do...Loops and Date Cell Defined as Date in VBA code 4
How to check for a date range match in one column and then count thevalues equal to in another 5
how to use lookup a value by date for criteria in Excel sheet 5
How do I use CountIf formula to count a within a range of numbers 0

Top