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
|