Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spread Sheets Subtitle Questions

    I am a student, and am having trouble! I am making changes to a spread sheet. I am not sure what is needed to receive an answer, as I am a first time visitor, so please excuse my mistakes!

    Here is the question:

    Add subtotals using the Subtotal button in the Outline group of the Data tab to the Total Cost column to calculate the sum and average total costs of videos by genre.

    Thank you.

  2. #2
    Plutonium Lounger Medico's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    12,631
    Thanks
    161
    Thanked 936 Times in 856 Posts
    Welcome to the Lounge, I do not have an answer, but....

    Moderator or Administrator, this should go in the Spreadsheets forum.
    BACKUP...BACKUP...BACKUP
    Have a Great Day! Ted


    Sony Vaio Laptop, 2.53 GHz Duo Core Intel CPU, 8 GB RAM, 320 GB HD
    Win 8 Pro (64 Bit), IE 10 (64 Bit)


    Complete PC Specs: By Speccy

  3. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,188
    Thanks
    47
    Thanked 983 Times in 913 Posts
    Somebody please do this lady's homework for her.

    cheers, Paul

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    First select your data range. Then, per the instructions you have, click on the Data tab, then in the Outline group use the subtotal feature.

    It might look something like this sample (attached).

    Clip0009.jpg

Posting Permissions

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