| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT WITH WILDCARD
Dave,
Brilliant! It was the #N/A in column F! Sorted it, many thanks. -- Mark "Dave Peterson" wrote: What formula did you use? Do you have #n/a's in either of those two ranges? Mark wrote: Thanks Dave, but I'm getting #N/A and I can see there are some rows with this info! Can you offer any suggestion? -- Mark "Dave Peterson" wrote: =sumproduct(--(left(f1:F100,3)="npt"),--(left(a1:a100,2)="pc")) You can't use whole columns with this kind of formula. Mark wrote: Can someone assist me with a formula to sumproduct with wildcards, please? =SUMPRODUCT(--(F:F="NPT*"),--(A:A="PC*")) I've got this but it doesn't work!! -- Mark -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wildcard in sumproduct? | Excel Worksheet Functions | |||
| Using Wildcard characters in sumproduct | Excel Worksheet Functions | |||
| SUMPRODUCT with Wildcard | Excel Worksheet Functions | |||
| Sumproduct Wildcard | Excel Discussion (Misc queries) | |||
| Sumproduct with Wildcard * | Excel Worksheet Functions | |||
Threaded Mode
