The formula I gave you works fine in a test workbook. Again, the
comparisons you're making are inverted logic - the comparisons should be

<start date range <=D8

and

<end date range =D8

The #REF! error would indicate that your references were bad - are you
sure that your sheet is named "Sheet2"?


In article <_GY_e.283159$tt5.57408@edtnps90,
"Jim" wrote:

Neither works, getting #REF errors, I tried changing it slighly to match the
cells I actually use in the columns to no avail.. Just to make sure as I
have limited experience with excel, I am entering this formula into F8 cell
on sheet1 (Where I want the results to show)

=SUMPRODUCT(--(Sheet2!A3:A36=D8),--(Sheet2!B3:B36<=D8),C3:C36)