+ Reply to Thread
Results 1 to 4 of 4

SUMPRODUCT Help

  1. #1
    Registered User
    Join Date
    11-18-2015
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    5

    SUMPRODUCT Help

    Hello Excel Forum,

    Hope all is well.

    I am looking for a SUMPRODUCT formula (or a better formula if you can think of it) to give me the sum based on certain criteria. I have an attachment to follow along with... but what I am looking to do is the following:

    I have dates in column A, and in column B I would like to obtain the SUM of certain Fruits and their Values, based on a certain date, but only if the Fruit is found in the listing in another column. So in my attached example, I am looking for a formula in the green cells (column B) and I would like them to say: Ok... look in column H (raw data)... if the Fruit listed in Column D is found in column H... SUM it but ONLY if it is on the given date... So in B2 I should receive the total $$ value (column I) for only Apples and Oranges (column D) that have matching dates in column G. So in B2 I should have only 10/1/2015 Apple and Orange $$ values... The end goal is for me to be able to delete a fruit option in column D, and have the formula in column B to auto update.

    I am essentially trying to do a SUMIFS... with two different criteria, but I want one of the criteria to be variable... based on a list. So if the list changes, you don't have to change each SUMIFS reference.

    Been trying to figure this out for SOOOOO long... So if you can help me out with this one.. you will be a savior!

    Thanks in advance for your help!

    Gladston
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: SUMPRODUCT Help

    Here, try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    However, you need to change "Apples" from D3 into "Apple" to have exact match.

  3. #3
    Registered User
    Join Date
    11-18-2015
    Location
    Madrid
    MS-Off Ver
    2016
    Posts
    95

    Re: SUMPRODUCT Help

    Hi, this should work:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-18-2015
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    5

    Re: SUMPRODUCT Help

    Zbor!

    Thank you so much!! This seems to work perfectly! I am forever indebted! And thank you, too, for the very timely response.

    Much appreciated,

    Gladston

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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