+ Reply to Thread
Results 1 to 2 of 2

Multiple total rows for tables

  1. #1
    Registered User
    Join Date
    08-14-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Multiple total rows for tables

    Can I add more than 1 "Total row" for a table? I want 1 for average and 1 for standard deviation. I'm trying to check the box that says "Total row", but it only will give me 1 row.

    Thanks

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Multiple total rows for tables

    Well, averages and standard deviations aren't "totals" per se, so you cannot have total rows for these.

    Assuming the table is not just a data range, but a true Excel 2007+ table:

    Insert new rows for average and standard deviation below the totals row, leaving at least one empty row in between.

    For either measure, reference the table in the formula so that the formula adjusts automatically for added/deleted data.

    =AVERAGE(TABLE1[MyTableColumn])

    Where "MyTableColumn" is the header for whichever column values you want to average.
    If you have given the table a name, replace Table1 with the actual name of the table.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1