Sumproduct - Using multiple conditions

1. 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

2. 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)

3. 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. Re: Sumproduct - Using multiple conditions

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

5. 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

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

6. 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:

copied down should work.

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

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