| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT multiple critera from different worksheets | Excel Worksheet Functions | |||
| Sumproduct across multiple worksheets | Excel Worksheet Functions | |||
| SUMPRODUCT on multiple values | Excel Discussion (Misc queries) | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
