+ Reply to Thread
Results 1 to 4 of 4

Calculating sums, referring to adjacent cells

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    76

    Calculating sums, referring to adjacent cells

    This is a continuation of a question I had earlier today.

    I have a column with several different names, each repeated a number of times. I have four columns to the right with numbers in them. I would like to calculate a sum of the numbers in each column for each grouping of a particular name. For example, for all rows with the name "aa" I would need a sum of column B, a sum of column C, a sum of column D, and a sum of column E. Then I would want to get a sum of the next grouping of names ("ab"), etc. etc.

    I've attached an example.

    Thanks in advance!!
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Calculating sums, referring to adjacent cells

    Extract the unique values from column A using advanced filter to column I and then

    =SUMIF($A$1:$A$31,$I1,B$1:B$31) >> drag down and across

    http://www.techrepublic.com/blog/mso...cel-column/637
    Last edited by jeffreybrown; 05-18-2012 at 03:59 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    04-11-2012
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Calculating sums, referring to adjacent cells

    Fantastic! Thanks!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Calculating sums, referring to adjacent cells

    You're very welcome. Glad to have help and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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