Total based on two criteria

So Column A is a list of names,
Column B is a list of times in hours and minutes
Column C is a list of dates that the times occurred

In worksheet 2 i want to return the sum of times that occurred for a person between specific dates.
i.e all times for Joe bloggs between 01/07/08 and 08/07/08

I have worked out a formula for the sum if the name matches for times allready would i be able to add to this to only include the particular dates(and if so how?) or do i need some other formula.

Any help would be appreciated i am terrible at this sort of thing....

Welcome to the forum.

Your title has being amended. Please take 5 mins to read the forum rules below before posting again.

Try

=SUMPRODUCT((Sheet1!A2:A200="Joe Bloggs")*(Sheet1!C2:C200>=DATEVALUE("01/07/08"))*(Sheet1!C2:C200<=DATEVALUE("08/07/08"))*(Sheet1!B2:B200))

Format the formula cell as

[h]:mm

NOTE You can't select the whole column in Sumproduct formulas.

VBA Noob