| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Left as a condition in SUMPRODUCT
This function works fine until I insert the LEFT condition. Any ideas
on how to make it work? I tried entering it as an array as well and nothing. Works: =SUMPRODUCT((Summary!M7:M65536=1)*(Summary!K7:K655 36=1),(Summary! J7:J65536)) Doesn't work: =SUMPRODUCT((Summary!M7:M65536=1)*(LEFT(Summary!K7 :K65536,1)=1), (Summary!J7:J65536)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use Sumproduct with the LEFT Function? | Excel Worksheet Functions | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| SUMPRODUCT AND LEFT | Excel Worksheet Functions | |||
| Left and Sumproduct | Excel Discussion (Misc queries) | |||
| LEFT embedded in SUMPRODUCT | Excel Programming | |||
Threaded Mode
