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
Bookmarks