| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct help
I have data on two worksheets and I want to sum data on one sheet if the data
on the second sheet matches. The data in sheet one is either 4, 7, or 10 digits (and is in text format, xxxx-xx-xx) but sheet 2 is only 4 digits. I have the formula below but it returns zero and that isnt right. What do I need to do to fix this? =SUMPRODUCT(--((LEFT(TRIM('sheet 1'!A2:A3000),4))='sheet 2'!B349),'sheet 1!'B2:B3000) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
