Results 1 to 4 of 4

Thread: Excel

  1. #1
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I would like to sum by area codes in the attached spreadsheet and also be able to views the results by year. Is there a function that will allow me to do this?

    Many thanks
    bk
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could create a pivot table:
    - Click anywhere in the data.
    - Activate the Insert tab of the ribbon.
    - In the Tables group, click PivotTable, then select PivotTable from the dropdown.
    - Specify where you want the pivot table: on a new sheet or in the current sheet, then click OK.
    - Drag Area to the Row Labels box, Year to the Column Labels box, and Gross Value to the Values box.

    See the attached version (I created the pivot table in Excel 2003 so it may look slightly different than one created in Excel 2007)
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Jun 2007
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. However can you create a pivot table from more than one tab? bk

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There is an option to Consolidate multiple worksheets into one PivotTable report but that is probably not what you want - it requires the data in the individual sheets to be in crosstab format.
    For a 'standard' pivot table, the source data should be a single table.

Posting Permissions

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