+ Reply to Thread
Results 1 to 4 of 4

Sumproduct two different columns

  1. #1
    Registered User
    Join Date
    12-13-2012
    Location
    Bodo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    8

    Sumproduct two different columns

    Hi - looking for a solution to keep track of bank transaction in a budget - both in and out

    With:

    =SUMPRODUCT(--(Table[[CAT]:[CAT]]=$C5);--(Month(Table[[DATE]:[DATE]])=G$3);--(Table[[IN]:[IN]]))

    Table1:
    DATE | CAT | IN | OUT
    ----------------------

    the transaction CATegory and Date place the amount from table - column IN to the corresponding cell in my budget.
    I would like my bank account to reflect both income an expenses from 2 columns in Table: IN and OUT.
    Can't figure out how to implement this in the above formula.

    Greatful for any help

    Workbook example:
    (see earlier post: http://www.excelforum.com/excel-form...h-problem.html)
    Thanks to TMS

    Nordmann

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Sumproduct two different columns

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    12-13-2012
    Location
    Bodo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Sumproduct two different columns

    Hi sorry, no one replied to this post.
    Solution is to be find here:
    http://www.excelforum.com/excel-form...ml#post3632955

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Sumproduct two different columns

    Duplicate thread, hence closed.

    Nordmann, please check rule 5 in the forum rules page (http://www.excelforum.com/forum-rule...rum-rules.html) for future reference.

+ 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. SUMPRODUCT across several columns
    By BobTheRocker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-12-2011, 06:05 PM
  2. Excel 2007 : SUMPRODUCT over several columns
    By bkatzman in forum Excel General
    Replies: 15
    Last Post: 02-18-2010, 03:58 PM
  3. Sumproduct columns?
    By m5rcc in forum Excel General
    Replies: 1
    Last Post: 01-20-2009, 05:38 AM
  4. Replies: 9
    Last Post: 09-18-2008, 08:41 PM
  5. [SOLVED] sumproduct of columns
    By DJS in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2006, 03:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1