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