Sum data by a given date

  • I need to sum column 2 based off of a given date. My data table is huge and I need to sum every individual months data over past years to display on another sheet.


    Given Date (1/20/2009, 2/28/2009, etc.)


    [TABLE="width: 112"]

    [tr]


    [TD="align: right"]1/2/2009[/TD]
    [TD="align: right"]0.04[/TD]

    [/tr]


    [tr]


    [TD="align: right"]1/5/2009[/TD]
    [TD="align: right"]0.05[/TD]

    [/tr]


    [tr]


    [TD="align: right"]1/6/2009[/TD]
    [TD="align: right"]0.05
    [/TD]

    [/tr]


    [/TABLE]
    [TABLE="width: 112"]

    [tr]


    [TD="align: right"]2/2/2009[/TD]
    [TD="align: right"]0.19[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2/3/2009[/TD]
    [TD="align: right"]0.28[/TD]

    [/tr]


    [tr]


    [TD="align: right"]2/4/2009[/TD]
    [TD="align: right"]0.26
    [/TD]

    [/tr]


    [/TABLE]


    Any help would be greatly appreciated. Thanks!

  • Re: Sum data by a given date


    With your data in the range A2 to B7 and the date you wish to sum on in A1, try this:


    =SUMIF(A2:A7,A1,B2:B7)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!