Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
required excel 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
required excel 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Required fields in Excel | New Users to Excel | |||
More Excel Tutorials/Tips Required | New Users to Excel | |||
Excel Genius Required! | Excel Discussion (Misc queries) | |||
Excel macro required | New Users to Excel | |||
Help required in merging two formulas into one | Excel Worksheet Functions |