Hi Kostis

Having used the function it only returns a 1 to show that there is dat there
and not the actual number of the hours which is what I need. Any ideas please?

Thanks again

Nigel

"vezerid" wrote:

In general this is a problem of "SUMIF with Multiple Criteria" as it is
often asked in the newsgroups. The solution is the SUMPRODUCT function:

=SUMPRODUCT((A1:A100=123456)*(B1:B100=10)*(D1:D100 =--"04/04/06")*(C1:C100))

You can replace the constants with cell references. If so, you only
need to specify the cell for the date, i.e. D1:D100=K1, where K1 holds
the date.

HTH
Kostis Vezerides