Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Summing values according to dates

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a small summing problem. I'm trying to sum values per dates but the range of the dates are variable, ie. more than one value can exist for each date. For example A1:A5 contains (10.1.2001; 11.1.2002; 12.1.2002; 12.1.2002; 13.1.2002)
    and B1:B5 contains (2804; 198; 1176; 702; 1983)
    How can I get 4 sums out of this array with the 12th date summing up correctly.


  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Paul
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use the Data->Subtotals function.

    Cheers - Paul


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A pivot table might be good for this also. Plenty of good tips for PT's on the main Mr Excel site.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    390
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In column C: put all the dates of the month.
    In D1: put =SUMIF(A:A,"="&$C1,B:B)
    Copy this formula down.


    [ This Message was edited by: Albert 1 on 2002-04-19 05:53 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, this was exactly what I was looking for.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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