Hi,

In 2003 use

=SUMPRODUCT(--(D:D=C1),--(D:D<=D1),F:F)

Change the references as needed

Cheers,
Shane Devenshire

"Richard Manor" wrote:

Workbook to report all OT (overtime) performed during FY08 within a range of
date for comparison to current FY usage.

Two worksheets, 'Report' and 'FY08'. 'FY08'!D:D contains the dates the OT
was performed and 'FY08'F:F contains the number of hours performed for that
date.
Each row is another occurrence of OT performed. Worksheet 'Report' each row
holds the two dates for the criteria, in column C (start date) and column E
(end date), ie, 10/8/2007 and 10/12/2007. Equation for each row for sum of
hours performed within date range.

Problem: At home I have Excel 2007 and Excel 2003 at work. Solved the
equation in Excel 2007 as follows:
=sumifs('FY08'!F:F,'FY08'!D:D,"="&text(C2,"mm/dd/yyyy"),'FY08'!D:D,"<="&text(E2,""mm/dd/yyyy").
If there is a simpler way I'd love to see it. Back to the problem-

At work, Excel 2003 there is no SUMIFS function. Can not get it to work.
Tried SUMIF as follows:
=sumif('FY08'!D:D,(and(('FY08'!DD,"="&text(C2,"mm/dd/yyyy")),('FY08'!D:D."<="&text(E2,"mm/dd/yyyy")))),'FY08'!F:F) Tried CTRL+SHIFT+ENTER, still no joy.

Your suggestions please.