Results 1 to 5 of 5

Formula to match objects from 2 different worksheets, total linked sum

Threaded View

  1. 10-24-2019, 09:33 AM #1
    Tslack
    Tslack is offline
    Registered User
    Join Date
    10-24-2019
    Location
    Greenville SC
    MS-Off Ver
    2019
    Posts
    2

    Formula to match objects from 2 different worksheets, total linked sum

    I have a monthly workbook tracking sales and expenses.

    The banking tab, 1st attachment, shows the COA number in column E, associated cost in column D

    On the ledger Tab, 2nd attachment, I need to show the total sum of cost associated with the COA number
    I need the total to show in the 2nd attachment, yellow highlighted cell (column C)

    Bank Acct.JPGLedger.JPG

    I'm fairly new at more complicated formulas, not a pro at all
    Attached Files Attached Files
    Last edited by Tslack; 10-24-2019 at 10:49 AM. Reason: Attaching Example
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. automatically update excel linked pictures/objects
    By Darkenergyz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2014, 07:38 AM
  2. Linked Worksheet Objects in Word
    By matpj in forum Excel General
    Replies: 1
    Last Post: 05-06-2008, 12:47 AM
  3. Microsoft Linked Objects - Relative Paths
    By borat in forum Excel General
    Replies: 0
    Last Post: 07-26-2007, 08:26 AM
  4. [SOLVED] Displaying Linked and Embeded Objects in Excel
    By kearndog_13 in forum Excel General
    Replies: 0
    Last Post: 05-31-2005, 04:05 AM
  5. reconnec linked objects
    By Loretta Houston in forum Excel General
    Replies: 2
    Last Post: 04-12-2005, 04:19 PM
  6. [SOLVED] linked objects following and leading returns
    By timlishok in forum Excel General
    Replies: 0
    Last Post: 04-07-2005, 04:06 PM
  7. [SOLVED] linked objects following and leading returns
    By Tim Lishok in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-07-2005, 04:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1