One way...
To sum hours for Jan 2008:
=SUMPRODUCT(--(TEXT(Sheet1!B2:B20,"mmm/yyyy")="Jan/2008"),Sheet1!C2:C20)

Signature
Biff
Microsoft Excel MVP
>I have a data rage that column A is employee name, column B is date that
>the
[quoted text clipped - 3 lines]
> of
> the hours from a given month and total them up on the overview page.
Eagleryder - 19 May 2008 14:43 GMT
Thank you it worked like a charm.
> One way...
>
[quoted text clipped - 9 lines]
> > of
> > the hours from a given month and total them up on the overview page.
T. Valko - 19 May 2008 17:27 GMT
You're welcome. Thanks for the feedback!

Signature
Biff
Microsoft Excel MVP
> Thank you it worked like a charm.
>
[quoted text clipped - 14 lines]
>> > of
>> > the hours from a given month and total them up on the overview page.