+ Reply to Thread
Results 1 to 3 of 3

Sumif or Sumproduct with multiple criteria ??

  1. #1
    Forum Contributor
    Join Date
    08-10-2007
    Posts
    106

    Sumif or Sumproduct with multiple criteria ??

    Hi,

    i attached my excel file.. can someone help me fill the formula for C13 then copied down.


    The idea is to get match with Account and CostCenter then the sums are taken from A2 to J6

    Same accounts between Column A und J can happen several times so these needs to sum it up together too..
    if account matches with A2 Row to J2 row several times, then sum it up together aswell. then the next criteria is to get match with CostCenter
    the Costcenter are shown in Column L so the row belongs to this specific cost center.

    Account and costcenter needs to match up and then all matches will sum it up across several columns.

    F12 - F18 are example results..

    i dont know which formula suits for this better..?

    i know there are better ways to design the layout, but that is how the layout template i need to work with.

    thanks alot
    Attached Files Attached Files
    Last edited by Sultix; 09-06-2018 at 04:52 PM.

  2. #2
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Sumif or Sumproduct with multiple criteria ??

    Hi,

    There's a problem with your sample, A2:J2 are TEXT, you need to convert them to Numbers.
    Select A2:J2, Click the Exclamation diamond, select "Convert to Number".

    Then formula in C13 copied down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    08-10-2007
    Posts
    106

    Re: Sumif or Sumproduct with multiple criteria ??

    thanks you for suggestion, works fine like i wanted

+ 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/SUMPRODUCT Multiple Criteria
    By melissanelson110 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2017, 02:20 PM
  2. [SOLVED] Sumif or Sumproduct with multiple criteria
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2015, 06:25 AM
  3. [SOLVED] index match and sumproduct or sumif on multiple criteria
    By tabkaz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-02-2014, 06:20 AM
  4. Sumif or sumproduct with multiple criteria
    By msoregon91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2013, 03:56 PM
  5. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  6. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 AM
  7. SUMIF Multiple Criteria or SUMPRODUCT?
    By gdwright07 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-02-2008, 12:15 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