+ Reply to Thread
Results 1 to 4 of 4

somproduct with condition containing reference

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    Deventer, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    64

    somproduct with condition containing reference

    Hello,
    I'm in search for a sumproduct formula with a condition that uses a reference. I.o.w. in the attached file I'd like the yellow cells to return 45 and 45 respectively.

    Has anybody got an idea how to fix this?

    Kind regards,
    Niels
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: somproduct with condition containing reference

    My suggestion is in your Column G1 copy down the formula

    =SUMIF($A$1:$A$5,F1,$B$1:$B$5)+SUMIF($A$1:$A$5,F1,$C$1:$C$5)

    or it could be

    =SUMPRODUCT(($A$1:$A$5=F1)*($B$1:$C$5))

    hope it helps

    Rev12
    Last edited by Rev12; 06-15-2018 at 08:25 AM.

  3. #3
    Registered User
    Join Date
    06-13-2018
    Location
    india
    MS-Off Ver
    2010;2007
    Posts
    54

    Re: somproduct with condition containing reference

    hi ! try below in G1
    Formula: copy to clipboard
    Please Login or Register  to view this content.




    if this helps then add rep by clicking star at the bottom left corner of this post

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: somproduct with condition containing reference

    Not sure where you get 45 and 45 from? You have 54 appels
    =SUMPRODUCT(--($A$1:$A$5=F1),$B$1:$B$5*$C$1:$C$5)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] SOMPRODUCT from different columns multiplied by VAT factor
    By rvfotopro in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-02-2017, 10:08 AM
  2. Reference to cell by formula and condition
    By lucifender in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-02-2014, 08:03 AM
  3. IF function with a condition from reference cell
    By Markica85 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-20-2014, 01:27 PM
  4. [SOLVED] Cell Reference if condition match.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2012, 11:54 AM
  5. Somproduct
    By Selo in forum Excel General
    Replies: 4
    Last Post: 03-05-2008, 08:13 PM
  6. [solved] somproduct
    By Jaydubs in forum Excel General
    Replies: 2
    Last Post: 07-19-2006, 05:00 AM
  7. R1C1 style reference as Condition
    By aca in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-07-2006, 08:40 AM

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