Multiple cell data comparison and addition

[Car7os]

Hi

I wonder if anyone can help me, I have two databases which I fill out everyday and they share some of the same values and I would like to combine them to the one database, to do this I need to make a formula to collect some data.

For example I would like to know the total duration of setups that Ben did on machine 1 on the 04/06/13

In columns A,B,C and D is the data, I need a formula that will search column A for the selected date in H8 (the date contents in H8 will be linked to a user selectable date so I can have seperate monthly databases), and on that date search the multiple rows for a key word (Ben) and if there are any values in column D then add the multiple values to the contents of the formulation cell in K9.

I will taylor the formulas for each day and each machine, from this I can calculate my charts.

Many thanks

Carl

[Fotis1991]

One way.

In H9 and copy down ans across.

=SUMPRODUCT(($B$9:$B$24=$G9)*($A$9:$A$24=H$8)*($C$9:$C$24="Ben")*($D$9:$D$24))

[Car7os]

Hi Fotis

That is brilliant thanks

[Fotis1991]

........................

Also...

=SUMPRODUCT(($B$9:$B$24=$G9)*($A$9:$A$24=H$8)*($C$9:$C$24=RIGHT(E6,3))*($D$9:$D$24))