required excel formulas

  • Thread starter Thread starter Santosh
  • Start date Start date
S

Santosh

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
 
Back
Top