Excel SUMIF between dates

Question

I have column A with date values formatted as mm dd yyyy   I am trying to sum the values of column B if A   DATE 2012 1 1  AND    SUM B B  sums B properly  but if I try to use  SUMIF B B A A gt  DATE 2012 1 1   the value returned is 0 00   I m assuming this has something to do with using decimal for the sum and date type for the criteria   Is there a way to get around this   Thanks

User · Answer

To SUMIFS between dates  use the following    SUMIFS B B A A   gt    amp DATE 2012 1 1  A A   lt   amp DATE 2012 6 1

User · Answer

One more solution when you want to use data from any sell   in the key C3    SUMIF Sheet6 M M CONCATENATE   lt   TEXT C3  dd mm yyyy    Sheet6 L L

User · Answer

this works  and can be adapted for weeks or anyother frequency i e  weekly  quarterly etc      SUMIFS B12 B11652 A12 A11652      amp DATE YEAR C12  MONTH C12  1  A12 A11652   lt   amp DATE YEAR C12  MONTH C12  1 1

User · Answer

I found another way to work around this issue that I thought I would share    In my case I had a years worth of daily columns  i e  Jan-1  Jan-2    Dec-31   and I had to extract totals for each month  I went about it this way  Sum the entire year  Subtract out the totals for the dates prior and the dates after  It looks like this for February s totals    SUM  P3  NP3 - SUMIF  P 2  NP 2    gt 2 28 2014   P3  NP3  SUMIF  P 2  NP 2    lt 2 1 2014   P3  NP3     Where  P 2  NP 2 contained my date values and  P3  NP3 was the first row of data I am totaling  So SUM  P3  NP3  is my entire year s total and I subtract  the sum of two sumifs    SUMIF  P 2  NP 2    gt 2 28 2014   P3  NP3   which totals all the months after February and  SUMIF  P 2  NP 2    lt 2 1 2014   P3  NP3   which totals all the months before February

User · Answer

You haven t got your SUMIF in the correct order - it needs to be range  criteria  sum range  Try    SUMIF A A   gt    amp DATE 2012 1 1  B B

[excel] Excel SUMIF between dates

Examples related to excel

Examples related to date

Examples related to sumifs