+ Reply to Thread
Results 1 to 4 of 4

Combine 3 tables into a final result

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Sofia, Bulgaria
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Combine 3 tables into a final result

    Hi,
    I have three sheets (one per month) in which are the clients and the products sold for the corresponding month. Every month new clients and products can appear. How can i calculate after 3 months how much each one sold (the result should be displayed in the 4th sheet).I have attached a file similar to what I have. Somewhere along the way I got lost looking for something similar on this wonderful forum. Someone can guide me in the right direction?
    Thank you!
    Attached Files Attached Files
    Last edited by 6StringJazzer; 02-10-2021 at 12:33 PM. Reason: better titles please

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Calculate sales by product across three sheets

    Hi sejur,

    Please edit the question in your thread to "Combine 3 tables into a final result". Please do this first so we can find your question later.

    Then - Excel works better with tables of data like shown in this example. I've used a Power Query Unpivot to convert your data to a better format. Then appended each to a combined table on the last sheet. I think you want a pivot table to show a total. I hope this is closer to what you want to see and ask about. Change the way you collect your data or learn about PQ and unpivot and append tables.
    PQ UnPivot Append Pivot for sejur.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,693

    Re: Calculate sales by product across three sheets

    Quote Originally Posted by MarvinP View Post
    Please edit the question in your thread
    I have done this because it is the member's first post.

  4. #4
    Registered User
    Join Date
    02-10-2021
    Location
    Sofia, Bulgaria
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Re: Combine 3 tables into a final result

    Thank you very much!I'm sorry about the ambiguous title.

+ 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. [SOLVED] Mathematical question or excel question? Multiple several numbers in a row.
    By douglascaixeta in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-22-2015, 05:48 PM
  2. [SOLVED] Objective Question: High light the right answer with green before next question.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2015, 12:38 PM
  3. database question, excel data sorting question
    By weblisterltd.com in forum Excel General
    Replies: 1
    Last Post: 12-17-2014, 01:35 PM
  4. code to progressively go throughly question based on answer to first question
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2014, 06:48 AM
  5. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  6. Replies: 3
    Last Post: 06-17-2011, 08:09 AM
  7. Two question, numeric code question and subtraction of two columns?
    By mgsweden78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2008, 02:50 AM

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