Results 1 to 6 of 6

Sumproduct - Using multiple conditions

Threaded View

  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

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