+ Reply to Thread
Results 1 to 3 of 3

Sumif multiple values

  1. #1
    Registered User
    Join Date
    05-02-2013
    Location
    Norway
    MS-Off Ver
    Excel 2013
    Posts
    12

    Smile Sumif multiple values

    Hi

    I want to create a spreadsheet where i can put multiple sumif criteria in a list and get the correct answer.

    Se example book.

    E.g if i want to sum the amounts in the B column refering to the account nr. in column A. i should get the value 300 and not 100 as i do in the spreadsheet.

    Also important is that if i at a later point increase the List with account 2060 i should get the value 500.

    All help is much appreciated

    accounting.xlsx

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Sumif multiple values

    =SUMPRODUCT(SUMIF(A4:A12,D4:D6,B4:B12))
    Try the above formula
    edit the ranges if needed
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Sumif multiple values

    the sumif should be
    =SUMIF(A:A,D4,B:B)
    BUT
    why should you get 300 and not 100

    you have 1 entry for account 1000 of 100 only
    Are you trying to sum all entries that is in the LIST column ?

    if so try
    =SUMPRODUCT((A4:A12=D4:D12)*(B4:B12))
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Sumif multiple text values
    By tschatz in forum Excel General
    Replies: 4
    Last Post: 08-05-2013, 10:20 AM
  2. Multiple sumif or if to find data based on many values.
    By culverhr in forum Excel General
    Replies: 4
    Last Post: 04-19-2012, 01:29 PM
  3. SUMIF Multiple values within Column
    By rstrosch in forum Excel General
    Replies: 1
    Last Post: 12-11-2011, 04:17 PM
  4. Multiple values in one cell for sumif function
    By bernard.x in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2010, 08:41 AM
  5. Using SumIF formulas with multiple lookup values
    By Chris Freeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2005, 09:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1