Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct help using wildcard
I have to fulfill three conditions from the three coloumns below
1st Pick 1's from Column A 2nd Pick A Company from Column B and 3rd Pick all starting from 46 in Column C Column A Column B Column C 0 A Company 46401000CC 1 B Company 46406500DC 0 C Company 54010000PO 1 A Company 46046544EJ 0 A Company 46330578LT 1 A Company 46301456DD Any help getting the formula with that would be greatly appreciated. Thanks in advance. KD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct + wildcard | Excel Worksheet Functions | |||
SUMPRODUCT WITH WILDCARD | Excel Discussion (Misc queries) | |||
SumProduct w/WildCard | Excel Worksheet Functions | |||
wildcard in sumproduct? | Excel Worksheet Functions | |||
Sumproduct with Wildcard * | Excel Worksheet Functions |