Selecting Specific Data By Dates

I would like to quantify quarterly data. My formula is currently set to identify a specific date registered, and then sum up all numbers by that date. For example, if the specified date is "7/25/16" all data for that date is automatically added together. However, I'm not sure how to set up the function so that it reads all dates in this quarter. Attached are screen shots/dummy copies for better understanding. Thank you!

Originally Posted by GeneralDisarray

I don't see any functions in the Excel file you attached.

But, if you are looking to find the Quarter for a given date, you could use the 'Choose' and 'Month' functions:

=CHOOSE(MONTH(Cell_With_Date_Value),"Q1","Q1","Q1","Q2","Q2","Q2","Q3","Q3","Q3","Q4","Q4","Q4")

Basically, that would assign a value like Q1 to any date from Jan,Feb,Mar etc. Could add a column for quarter and then use that in your function somehow?

Thanks i'll give it a try!

Originally Posted by JohnTopley

Try

=SUMIFS($I$2:$I$1008,D$2:D$1008,A1041,A$2:A$1008,">="&$A$1040,A$2:A$1008,"<="&EOMONTH($A$1040,0))

Appreciate the insight, JohnTopley. This looks like it may have worked. Can you explain what the function is saying? Not sure what <="&EOMONTH($A$1040,0))[/QUOTE] is doing. thank you!

For Quarter should be:

<="&EOMONTH($A$1040,2)

What is saying is add 2 months to your data in $A$1040 and then calculate the End of Month Date.

So if A1040 = 4/7/2016, then add 2 months to give 9 then take the end of this month i.e 30/09/2016 (UK date formats!)

Everyone has been great. Shout out to JohnTopley for the fix!