| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct with text values
I cant get either of these formulas:
=SUMPRODUCT(--('Assignments Copy'!C:C="Text 1"),--('Assignments Copy'!J:J="Text 2"),--'Assignments Copy'!H:H) or =SUMPRODUCT(('Assignments Copy'!C:C="Text 1")*('Assignments Copy'!J:J="Text 2")*('Assignments Copy'!H:H)) to return the proper result. In my test example, I should get 1.00, but I get a #VALUE error. Thoughts? Any help is appreciated. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Sumproduct return Text values | Excel Worksheet Functions | |||
| Two Matches, then Sumproduct of Values | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| SUMPRODUCT rounding up values | Excel Worksheet Functions | |||
| Obtaining Max and Min Values with Sumproduct | Excel Discussion (Misc queries) | |||
Threaded Mode
