+ Reply to Thread
Results 1 to 4 of 4

Sum product with multiple creiteria

  1. #1
    Registered User
    Join Date
    05-03-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    11

    Sum product with multiple creiteria

    Hi,

    Can somebody please help me to get the formula for sum-product with multiple criteria (minimum 3 criteria)

    Thanks in advance,
    TJ7009

  2. #2
    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
    53,049

    Re: Sum product with multiple creiteria

    Hi, welcome to the forum

    Yes, Im sure someone can - as soon as you give some details on what you have - and what you want
    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

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,068

    Re: Sum product with multiple creiteria

    There's a good tutorial here: http://chandoo.org/wp/2011/05/26/adv...oduct-queries/
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Sum product with multiple creiteria

    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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] Product After Multiple Criteria Are Met
    By JC1407 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-07-2016, 04:54 PM
  2. SUMPRODUCT with morethan one creiteria
    By tonisjoseph in forum Excel General
    Replies: 4
    Last Post: 01-10-2016, 03:02 AM
  3. Macro to sum the product of multiple cells across multiple worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 03:28 PM
  4. sum product w/ multiple criteria
    By TechRetard in forum Excel General
    Replies: 4
    Last Post: 09-06-2011, 03:32 PM
  5. Replies: 2
    Last Post: 04-02-2009, 05:56 AM
  6. Sum Product Multiple Criteria
    By PeterSmith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2008, 12:07 PM
  7. Sum of Product Multiple Columns/Multiple Sheets, Indefinite Range
    By endurion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2007, 05: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