Results 1 to 4 of 4

Sum the difference in amounts if items are in two tables

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    21

    Sum the difference in amounts if items are in two tables

    I have two tables that have data. One has estimated amounts and one has actual amounts. So, suppose I have a person (Steve) that we anticipate will buy oranges for $4 (Worksheet 1), but he actually buys the oranges for $5 (worksheet 2). The difference is $1. What I want to do is to add up all of the differences between worksheet 1 and worksheet 2, but only when the person on worksheet 2 matches worksheet 1. By that I mean, if we have Oscar on worksheet 1, but not on worksheet 2, we don't need to worry about him. To add to this, I also only want to add the difference if the currency is a certain currency (USD). I'm attaching a file so you can see.

    Can someone help me with the right formula? I'm thinking sumproduct will work, but I don't understand that formula enough to make it work.
    Attached Files Attached Files

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