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 ***

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 ***

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 ***