Results 1 to 5 of 5

Summarizing values from different worksheets to one summary worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2011
    Location
    new york,USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Summarizing values from different worksheets to one summary worksheet

    Happy New Year!
    I have two worksheets showing shopping cost summary for Person A and Person B. Each person enters the price of the item they purchase as the purchases are being made so there will be duplicate item entries with different prices (i.e. an eraser costs $4 in shopA but $3 in shopB, these values were entered separatedly)

    I have a cost Summary worksheet that list all the items these two shoppers will eventually purchase. How can I summarize the inputs from PersonA and PersonB's shopping list in the cost summary sheet without going through each item and adding the cost one by one as I've done here?

    Thanks!
    Attached Files Attached Files
    Last edited by lkim; 01-04-2012 at 12:12 PM.

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