sumproduct multiple values on other worksheets
 

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

sumproduct multiple values on other worksheets
 

Are your ranges the same size?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike" wrote in message
...
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