Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Feb 2005
    Location
    Albuquerque, New Mexico, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SUMIF Date Range (2003)

    I need to sum the totals in column B based on a date range in Column A. I will be creating a Sum of January totals, February Totals, March Total, etc. I can get it to add if I use a >date, but not between dates.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUMIF Date Range (2003)

    For January, it would be

    =SUMIF(A1:A22,">=1-Jan-05",B1:B22)-SUMIF(A1:A22,">=1-Feb-05",B1:B22)

    Another possibility would be to add a column that calculates the month: e.g. enter the formula =MONTH(A1) in C1 and fill down as far as needed. This column can be hidden. The SUMIF formula for January would be

    =SUMIF(C1:C22,1,B1:B22)

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: SUMIF Date Range (2003)

    For January:
    =SUMIF(A1:A22,">="&DATE(2005,1,1),B1:B22)-SUMIF(A1:A22,">="&DATE(2005,2,1),B1:B22)

    For Feb
    =SUMIF(A1:A22,">="&DATE(2005,2,1),B1:B22)-SUMIF(A1:A22,">="&DATE(2005,3,1),B1:B22)

    etc

    Steve

  4. #4
    Lounger
    Join Date
    Feb 2005
    Location
    Albuquerque, New Mexico, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SUMIF Date Range (2003)

    You two are masters and don't get paid enough! <img src=/S/money.gif border=0 alt=money width=17 height=15>

    Many thanks

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: SUMIF Date Range (2003)

    I don't know about the first, but I agree with the last! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •