+ Reply to Thread
Results 1 to 4 of 4

SumProduct? on 2 elements

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    N/A
    MS-Off Ver
    MS 365
    Posts
    70

    SumProduct? on 2 elements

    Hello

    I would like a formula to pick up two elements, both currency and cost description, and to sum based on that.

    I have tried and failed to figure out the sumproduct and index/match

    Would appreciate some tips

    Many thanks, Maddy
    Attached Files Attached Files
    Last edited by overbomb; 03-22-2012 at 07:04 AM.

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: SumProduct? on 2 elements

    Hi

    Fill out some data and show expected results

    Also write the somproduct formula you used

    Regards
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: SumProduct? on 2 elements

    In B4, enter =SUMPRODUCT((DATA!$I$2:$I$38=B$4)*(DATA!$J$2:$J$38=$A5)*DATA!$G$2:$G$38) and drag it down and across

  4. #4
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: SumProduct? on 2 elements

    Did this solution work for you?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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