+ Reply to Thread
Results 1 to 6 of 6

Sumproduct - Using multiple conditions

  1. #1
    Registered User
    Join Date
    01-20-2008
    Location
    Sevenoaks, Kent Great Britain
    MS-Off Ver
    2010
    Posts
    54

    Sumproduct - Using multiple conditions

    I want to look at column "C" if column "C" contains "Giro:Maestr-E (enter date)" and column "C" contains "Giro:Duality-E (enter date)" then if column "F" is the same day, written in the format of text as eg "19th January" then add the two figures in column "H"

    In the enclosed example give a figure of 3919.15


    I have tried adapting this formula but I just cant get it to look at all the conditions and return the right answer.

    =SUMPRODUCT(--(($C$15:$C$2500="Giro:Duality-E (enter date)")+($C$15:$C$2500="Giro:Maestr-E (enter date)")),--

    I have read the notes on Sumproduct but I just cant get it.

    David
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Sumproduct - Using multiple conditions

    Try:

    =SUMPRODUCT((($C$1:$C$11="Giro:Maestr-E (enter date)")+($C$1:$C$11="Giro:Duality-E (enter date)")),--($F$1:$F$11=F4),$H$1:$H$11)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    01-20-2008
    Location
    Sevenoaks, Kent Great Britain
    MS-Off Ver
    2010
    Posts
    54

    Re: Sumproduct - Using multiple conditions

    Hi Many thanks for that. I didnt make myself very clear. What I ideally want is when say the 19th of Jan Matches the two amounts are added together and then stored in a cell, then if the 20th matches thats stored in a cell. Again ideally if 19th matches the amount is shown then the next cell shows 19th Jan.


    Sorry I didnt explain correctly.


    David

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Sumproduct - Using multiple conditions

    I am confused, can you repost your sample and show the entire expected results you want to see?

  5. #5
    Registered User
    Join Date
    01-20-2008
    Location
    Sevenoaks, Kent Great Britain
    MS-Off Ver
    2010
    Posts
    54

    Re: Sumproduct - Using multiple conditions

    Hi I have attached another copy. So when the dates match ( for the Giro:Duality-E (enter date) & (Giro:Maestr-E (enter date) the total is displayed in column "J" for each date


    Quote Originally Posted by NBVC View Post
    I am confused, can you repost your sample and show the entire expected results you want to see?
    Attached Files Attached Files

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Sumproduct - Using multiple conditions

    In this case why doesn't the Jan 20th apply? It seems to have proper conditions...

    If you made an error then I think this formula in J3:

    Please Login or Register  to view this content.
    copied down should work.

+ 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