| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two criteria
Hi, Can any one help me.on finding solution on counting two criteria in Excel-2003.(By vbe code, macro or??) I have my stock sheet with multiple entry i have to count how many mother with model(Intel915) is out. In below mention format. Mother Board As per reporting sheet Opn Stock Purchases Rental Inward Replacement-IN Replacement-OUT Sale/Scrap Closing Stock Physical Stock Difference At Hand At Client OUT IN At Hand At Client At Hand INTEL 915GVSR 1 - - 12 - - 12 - 0 12 INTEL D915GLB 1 - - 1 - 1 2 (1) 0 2 INTEL D101 GGC 144 - - 147 - 147 - 0 147 INTEL D946GZIS 6 - - 6 - 6 - 0 6 INTEL D946GZIS 75 - - 75 - 75 - 3 72 Intel D102 1 - - 1 - 1 - 0 1 Intel- 945 2 - - 2 - 2 - 0 2 MSI VIA 5 - - - - - 0 - SE7525RP2 - - - - - 0 - Regards Basant *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two criteria
Have a look at
Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "basant upadhyay" wrote in message ... Hi, Can any one help me.on finding solution on counting two criteria in Excel-2003.(By vbe code, macro or??) I have my stock sheet with multiple entry i have to count how many mother with model(Intel915) is out. In below mention format. Mother Board As per reporting sheet Opn Stock Purchases Rental Inward Replacement-IN Replacement-OUT Sale/Scrap Closing Stock Physical Stock Difference At Hand At Client OUT IN At Hand At Client At Hand INTEL 915GVSR 1 - - 12 - - 12 - 0 12 INTEL D915GLB 1 - - 1 - 1 2 (1) 0 2 INTEL D101 GGC 144 - - 147 - 147 - 0 147 INTEL D946GZIS 6 - - 6 - 6 - 0 6 INTEL D946GZIS 75 - - 75 - 75 - 3 72 Intel D102 1 - - 1 - 1 - 0 1 Intel- 945 2 - - 2 - 2 - 0 2 MSI VIA 5 - - - - - 0 - SE7525RP2 - - - - - 0 - Regards Basant *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Two criteria
Here is a link to counting with multiple criteria...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "basant upadhyay" wrote: Hi, Can any one help me.on finding solution on counting two criteria in Excel-2003.(By vbe code, macro or??) I have my stock sheet with multiple entry i have to count how many mother with model(Intel915) is out. In below mention format. Mother Board As per reporting sheet Opn Stock Purchases Rental Inward Replacement-IN Replacement-OUT Sale/Scrap Closing Stock Physical Stock Difference At Hand At Client OUT IN At Hand At Client At Hand INTEL 915GVSR 1 - - 12 - - 12 - 0 12 INTEL D915GLB 1 - - 1 - 1 2 (1) 0 2 INTEL D101 GGC 144 - - 147 - 147 - 0 147 INTEL D946GZIS 6 - - 6 - 6 - 0 6 INTEL D946GZIS 75 - - 75 - 75 - 3 72 Intel D102 1 - - 1 - 1 - 0 1 Intel- 945 2 - - 2 - 2 - 0 2 MSI VIA 5 - - - - - 0 - SE7525RP2 - - - - - 0 - Regards Basant *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| have input box. Need criteria entered to refer to cond. format criteria | Excel Programming | |||
Linear Mode
