Formula for in between dates

In this spreadsheet, I'm attempting to sum by a month date range and account number so my end results would be something like this:
I'm using the SUMIFS function to look at the original spreadsheet that looks like this:

(Pulling from the detail invoices spreadsheet)

What I need to do is to be able to update the date for each month, (July totals, Aug totals, Sept, Etc.) but when I use <08/30/2014, etc it pulls July and August in my monthly report and I want the report by month. Can you help?
Thank you for any help.
Andrea

You would need something like:

=SUMIFS(DETAILS!F3:F19, DETAILS!B3:B19,">=07/01/2015",DETAILS!B3:B19,"<=07/31/2015",DETAILS!A3:A19,"=2720512")

or, assuming your headers are actual 1st of the month dates, formatted as MMM-YY, starting in C1 then you can use those in the formula

=SUMIFS(DETAILS!F3:F19, DETAILS!B3:B19,">="&C$1,DETAILS!B3:B19,"<="&EOMONTH(C$1,0),DETAILS!A3:A19,"=2720512") copied across.

and if the 2720512 corresponds to a value in the KTC or Operating Expenses column, you can use that reference so you can further copy down this formula:

=SUMIFS(DETAILS!F3:F19, DETAILS!B3:B19,">="&C$1,DETAILS!B3:B19,"<="&EOMONTH(C$1,0),DETAILS!A3:A19,$B2)

where B2 contains 2720512...

OK, this worked great! Thanks.

Now, what i need to be able to do is, on the details tabs, as I add invoices, i need the formulas to dynamically update so that I don't have to go in every time and change my cell ranges in the sumifs formulas. So like the range now is f3 thru F19 but as I add invoices, that will increase.

is that something that can happen dynamically?

Go to the Details tab, and then go to Formulas, then Define Name.

Enter a Name for the range, e.g. Details

Then enter formula for source: =OFFSET(DETAILS!$A$1,,,COUNTA(DETAILS!$A:$A),6) where 6 is number of columns to include (from A to F = 6 columns).

Now change formula to:

=SUMIFS(INDEX(Details,0,6), INDEX(Details,0,2),">="&C$1,INDEX(Details,0,2),"<="&EOMONTH(C$1,0),INDEX(Details,0,1),$B2)