Thursday, June 12, 2014

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


                                         Google Spreadsheet   Post  #1668
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-12-2014
post by Bryce Evans: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/eLXNaPwlRak)
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?
--------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment