required excel formulas

Cat Article no impresion of

01 801-1110 -
02 801-1111 -
01 801-4111 +
03 801-5222 +
04 801-4666
01 801-7485 -

i want to count - ,+,blank according to cat.Pls help me with formulas

try this. UNtested

=sumproduct((a2:a22="01")*(c2:c22="+))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Santosh" wrote in message
...
Cat Article no impresion of

01 801-1110 -
02 801-1111 -
01 801-4111 +
03 801-5222 +
04 801-4666
01 801-7485 -

i want to count - ,+,blank according to cat.Pls help me with formulas

A pivot table is ideal. You'd get the results in a matter of seconds with a
few clicks, drags n drops ..

Some easy steps to lead you in (Excel 2003):
Select any cell within the table
Click Data Pivot table
Click Next Next
In step 3 of the wiz, click Layout:
Drag n drop "Cat" in ROW area
Drag n drop "impresion of" in COLUMN area
Drag n drop "impresion of" in DATA area (it'll appear as Count)
Click OK Finish. That's it.
Hop over to the pivot sheet (to the left) for the results
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"Santosh" wrote:
Cat Article no impresion of
01 801-1110 -
02 801-1111 -
01 801-4111 +
03 801-5222 +
04 801-4666
01 801-7485 -

i want to count - ,+,blank according to cat. Pls help me with formulas