+ Reply to Thread
Results 1 to 2 of 2

Summing Amount party wise

  1. #1
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    727

    Summing Amount party wise

    Dear Members

    I have 6 total queries totling amount on party basis (6 individual tables.

    Now I am trying to evaluate (Plus or minis) the amount on party wise and appen it to another table (Trial Balance).

    In query No. 7 i have tried something but failed.

    Help me to solve the problem. (File attached)
    Any query or code will do

    Regards
    Attached Files Attached Files
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    727

    Re: Summing Amount party wise

    Dear Members
    I have solved it myself

    Take two tables at a time and create total query on party .
    Then another query with the above and a new one and so non.
    If you have query too comp;lex error, append the result of previous query and then continue with that table and another neew one.

+ 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: 23
    Last Post: 06-20-2017, 04:17 AM
  2. [SOLVED] sumproduct formula for summing desingation wise
    By srinivasan1965 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-30-2016, 05:40 AM
  3. [SOLVED] VBA -- Need help in Summing values from Visible Cells (row-wise)
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-07-2014, 09:37 AM
  4. vba code for automating branch wise day wise amount to summary file
    By pranithpm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 04:18 AM
  5. Replies: 2
    Last Post: 11-03-2013, 03:49 PM
  6. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  7. Segregation of Rows Amount Wise
    By khawarameer in forum Excel General
    Replies: 1
    Last Post: 01-02-2010, 05:36 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