Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Thanked 0 Times in 0 Posts

    Sum after each month (2000)

    Hi, I'm so glad there is a woody's lounge. Is there a formula to have Excel sum after each month? I have attached a sample. Column A has months 01-Apr-05 and Column B is a count of how many people came for help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Sum after each month (2000)

    A pivot table is eminently suitable for this:

    - Clear columns C and D (or insert an empty column C)
    - Click somewhere in the table.
    - Select Data | PivotTable and PivotChart Report...
    - Click Next.
    - Click Next again.
    - Click Layout.
    - Drag Date to the Row area.
    - Drag Count to the data area.
    - Click OK.
    - Specify whether you want the pivot table in a new sheet or on the current sheet.
    - Click OK.
    - Click anywhere in the Date column in the pivot table.
    - Select Data | Group and Outline | Group...
    - Select Months from the Group dialog.
    - Click OK.

    It takes longer to write it out than to do it!

Posting Permissions

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