+ Reply to Thread
Results 1 to 2 of 2

Need help with a formula for summing different values that matches other value.

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    Need help with a formula for summing different values that matches other value.

    Hello All,

    I am facing a hard time deriving a formula for a situation. I have two different workbooks, one for bank transactions and other one for credit card transactions. Bank workbook shows transactions in batches while credit card workbook shows individual transactions. There is no common factor to link these sheets. Bank Transaction date and Credit Card Transaction date differs, so I cannot club date and amount here. Is there any way with the help of sumif or sumproduct and v-lookup I can return the credit card transaction date in front of bank value.

    For Example:

    Bank Workbook:

    Transaction Date - 09/12/2018
    Amount - 5000

    Credit Card Workbook:

    Transaction Date - 09/09/2018
    Amounts - 1500, 2000, 500, -500, 1000, 200, 300 (5000)


    Please help!

    Gaurav Dhir

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Need help with a formula for summing different values that matches other value.

    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 then scroll down to Manage Attachments to open the upload window.

+ 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: 13
    Last Post: 05-24-2018, 01:18 AM
  2. [SOLVED] Help Creating A Formula That Matches Values
    By artiststevens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2017, 06:30 AM
  3. [SOLVED] Summing duplicate values(matches) from hlookup, for EACH ROW.
    By ksk806 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-06-2016, 12:32 AM
  4. Replies: 5
    Last Post: 05-03-2016, 04:52 PM
  5. [SOLVED] Summing the matches of one column only if its corresponding description matches a list
    By bishop-jese-erl in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-19-2015, 04:26 PM
  6. Replies: 1
    Last Post: 09-26-2013, 12:16 PM
  7. [SOLVED] V-lookup and summing values if more than 1 matches criteria
    By holcay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2006, 11:55 AM

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