Results 1 to 7 of 7

How to sum values based on multiple array values?

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Aalborg, Denmark
    MS-Off Ver
    Excel 2019
    Posts
    32

    How to sum values based on multiple array values?

    Hi guys

    I hope you can help me make a nice solution for this one.

    In the enclosed spreadsheet I am trying to sum the total sum range of column B where the value in column A is equal to a value in column C.

    I can express this in a SUMIF function as such: =SUMIF(A:A;C:C;B:B). The only problem with this is that I have to drill down with the formula so that it checks each criteria cell. I would like for it to sum it up in total in cell I have picked for the formula (f2 in my spreadsheet).

    Maybe sumproduct could be of help but I have not been able to make it work...

    Do any of you guys know of an easy solution?

    Thanks in advance
    Kind regards
    Morten
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-09-2018, 10:32 AM
  2. Converting an array of data into multiple arrays based on a single column values
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2018, 01:13 PM
  3. Filter an array based on multiple cell values
    By Perplexed99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2018, 03:07 PM
  4. Replies: 5
    Last Post: 07-31-2018, 01:43 PM
  5. Index array list based on multiple matching Values
    By Jpidge20 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-13-2018, 09:13 PM
  6. Array formula to return multiple values based on various (OR) criteria
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2013, 05:12 AM
  7. VBA.array to sum values based on multiple criterion and dates
    By Varmark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2011, 09:33 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