+ Reply to Thread
Results 1 to 3 of 3

References summations based on column and row number

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    50

    References summations based on column and row number

    Hi,
    I will begin with the code:
    Please Login or Register  to view this content.
    Essentially I want to have a list of summations based on column and row numbers so if I ask for Sum(1,2) it will give me the sum from row 1 column 2.
    Any help would be appreciated.

  2. #2
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: References summations based on column and row number

    row 1 column 2 is a single cell, why not reference it directly?

    #Edit

    Could you upload a sample workbook with mock data so i can better understand what your asking?
    Last edited by Steffen Thomsen; 05-25-2012 at 05:41 AM.
    Please take time to read the forum rules

  3. #3
    Registered User
    Join Date
    01-12-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: References summations based on column and row number

    Steffen,
    Thanks for the reply. I managed to work it out.

    Please Login or Register  to view this content.
    So this code will give a sum for each combination of rows 10 - 23 with columns 3 - 7

+ 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