+ Reply to Thread
Results 1 to 2 of 2

Conditional Sum Product

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Sum Product

    Hi Everyone!

    I'm having a horrible time trying to figure out how to achieve what I want in Excel. On the attached spreadsheet I have 5 columns listed as "Company Name","Amount","Ship Date", "Margin" and "Class". What I am trying to do is a sum product function that will multiply the "amount" by the "margin", but only if the "Company Name", "Ship Date" and "Class" in that row meet certain criteria. For example:

    Lets say that on the attached spreadsheet, I want to know overall margin for wall (class) orders that were shipped in January (ship date) for Store A (company name). I can get the information I want by just doing the sumproduct for those specific cells, but when I have a larger spreadsheet, I want to just be able to put in the formula and not have to search it all out myself.

    I would greatly appreciate any help anyone could give me, or if you could even point me in the right direction. I've tried everything I can think of to no avail.

    Thanks!

    Margin.xlsx

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional Sum Product

    Welcome to the forum,look below attachment if this is what you expect.

    Margin.xlsx
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. Conditional PRODUCT Function
    By andrewc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2014, 06:22 AM
  2. [SOLVED] Conditional PRODUCT Function
    By andrewc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2013, 02:32 AM
  3. Conditional product
    By Rodeo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2011, 09:21 AM
  4. Conditional product of sum
    By bdb1974 in forum Excel General
    Replies: 4
    Last Post: 03-03-2009, 07:07 PM
  5. [SOLVED] Conditional Sum Product
    By Ben010 in forum Excel General
    Replies: 12
    Last Post: 06-15-2006, 01:30 PM

Tags for this Thread

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