I am using the following formula:
=SUMPRODUCT(--(Month_yr=A1),--(sales_reps=A9),local_booked)

AI = the current month/yr A9=the sales persons name both of these are on
the same page as the formula.

Month_yr, sales_reps and local_booked are all on another worksheet within
the workbook. I keep getting an error #NUM!

Is it possible to lookup two different values, one being a date on another
worksheet.

Dazed and confused.

Mike