+ Reply to Thread
Results 1 to 3 of 3

Reference in first cell, several rows under with values, next reference follows

  1. #1
    Registered User
    Join Date
    07-10-2015
    Location
    Czech Republic
    MS-Off Ver
    MS 2013
    Posts
    4

    Reference in first cell, several rows under with values, next reference follows

    Hi there, I'm hoping to get help with a report, that I want to automatize.
    The data are organized in the following way - for example - cell A1 - reference, cells A2-A150 contain the description "transaction", cells D2-D150 contain the values; then cell A151 is blank, cell A152 contains new reference, cells A153-A220 description "transaction", cells D153-D220 values etc. I'm struggling to formulate a formula, which would ensure, that the values belonging to the respective reference are summed. Certainly, the transaction count varies. So basically I need to somehow instruct excel to find specific reference and get the total of all transactions from the area defined by the reference position and the very first next blank row.

    Can anybody help?

    Many thanks in advance.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Reference in first cell, several rows under with values, next reference follows

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    07-10-2015
    Location
    Czech Republic
    MS-Off Ver
    MS 2013
    Posts
    4

    Re: Reference in first cell, several rows under with values, next reference follows

    Hello, thank you for the response. In the meantime I have managed to solve this - using the find formulas.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 02-11-2015, 01:56 PM
  2. [SOLVED] Locked formula changes reference when rows added to reference sheet in same workbook
    By macrorookie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2014, 04:08 PM
  3. Reference cell values of rows in another table
    By firstnumber in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2013, 01:39 AM
  4. Replies: 2
    Last Post: 05-22-2012, 08:50 PM
  5. [SOLVED] UDF to return string of values of all rows with cell matching reference cell
    By oemgacaesar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2012, 12:43 PM

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