+ Reply to Thread
Results 1 to 4 of 4

SUM of Same item with multi-conditions

  1. 09-19-2015, 11:04 AM #1
    joejiang2001
    joejiang2001 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    24

    Lightbulb SUM of Same item with multi-conditions

    Hi, Guys

    I want to create a spreadsheet can SUM all the same item(sort by account numbers) with several conditions

    I tried SUMIFS() and Ubond(), It does not work

    Please Help, Great thanks for any idea!
    Untitled.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-19-2015, 11:57 AM #2
    buran
    buran is offline
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: SUM of Same item with multi-conditions

    I think SUMIFS should do the work. However it's not clear how you treat the amounts where days<0 for example why the amount for account 1002 is 85 171.25 when there are number of other amounts for this account.
    For example formula in L9 will be

    Please Login or Register  to view this content.
    And in M9 would be
    Please Login or Register  to view this content.
    If you are pleased with a member's answer then use the Star icon to rate it.
    Reply With QuoteRegister To Reply
  3. 09-19-2015, 12:12 PM #3
    joejiang2001
    joejiang2001 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    24

    Re: SUM of Same item with multi-conditions

    Thank you! Buran
    I might add your SUMIfs in this code below.
    If anybody has better idea
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 09-19-2015, 12:48 PM #4
    joejiang2001
    joejiang2001 is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    24

    Re: SUM of Same item with multi-conditions

    Solution uploaded, I figure it out, Pls download the Excel doc to check
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search and Copy based on multi-item tag list
    By Durbo94 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2015, 08:10 AM
  2. [SOLVED] Transferring data from multi item listbox into a cell
    By AndyMan81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2014, 06:31 AM
  3. enter multi item on cells from listbox
    By shayej in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2014, 08:20 PM
  4. Display multi line text in sub item of a listview .
    By priya06manohar@gmail in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 02:43 PM
  5. Conditional formatting - multi-item text list
    By String in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2006, 09:10 AM
  6. [SOLVED] Sorting through multi-item list
    By dravon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2006, 05:00 PM
  7. Multi Conditions
    By johntherevelato in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2005, 05:03 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1