## Thursday, June 12, 2014

### yogi_From A Table Of Dates And Amounts Compute Sum Of Amount By Each Month

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-12-2014
Sumif with Criteria set between two dates
I'm looking to add the values for everything within a specified time range of one month. I currently have:

=sumif(\$F\$2:\$F\$135,"<=5/31/2014",\$G\$2:\$G\$135)

That properly adds everything before May 31st.

I also have:

=sumif(\$F\$2:\$F\$135,">=6/1/2014",\$G\$2:\$G\$135)

That properly adds everything after June 1st.

In the future, I'll need to add future months and have everything for that month. I'll need something like:

=sumif(\$F\$2:\$F\$135,"<5/1/2014>5/31/2014",\$G\$2:\$G\$135)
or
=sumif(\$F\$2:\$F\$135,"5/1/2014><5/31/2014",\$G\$2:\$G\$135)

But neither of these works (they input the value "0").

I really want to make it between two set dates, not just after or above one specific date. What do I need to do in Google Sheets to achieve this?
--------------------------------------------------------------------------------------------------------------------------------------------