Excel Workbook | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
4 | 2011 01 | TUBE | 1 | |||||||
5 | 2011 01 | 3 | ||||||||
6 | 2011 01 | |||||||||
7 | 2011 01 | TYRE | 1 | |||||||
8 | 2011 01 | |||||||||
9 | 2011 01 | |||||||||
10 | 2011 01 | STEEL PLATE | 1 | |||||||
11 | 2011 01 | |||||||||
12 | 2011 01 | |||||||||
13 | 2011 01 | |||||||||
14 | 2011 01 | |||||||||
15 | 2011 01 | |||||||||
16 | 2011 01 | |||||||||
Sheet1 |
If the cell entry always starts with the word "tyre" then you can do something like this:Thank you very much. Its works for certain limitations.
If I just only want to know how many tyres being issued from store for that particular month and doesn't matter what brands and sizes of tyres. ( Tyre-Bridgestone 15", Tyre-Bridgestone 14", Tyre-Dunlop 15", Tyre-Dunlop 14" etc)
Can I insert wild card character (ie ?, *, ~) into the formula and how to integrate in? I have been tried it for many ways but doesn't work. Please help me to fix this problem.
=SUMPRODUCT(--(A4:A17="2011 01"),--(ISNUMBER(MATCH(C4:C17,{"STEEL PLATE","TUBE*","TYRE*"},0))),G4:G17)