Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count cell based on 2 Criteria
Greeting,
I have two columns, E&D. E has a material number and D has the size. There is more than one size for one material. What I want to do is count the number of size base one size and material. For example: Material# size 1 1 2 2 2 1 1 3 2 1 3 4 Summary: Material # size count 1 1 1 2 1 2 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count cell based on 2 Criteria
A pivot table is quite ideal, gives you the full summary
in a matter of seconds with a few clicks, drags n drops Select any cell in your table, click Data Pivot table Click Next Next In step 3 of the wiz., click Layout, then: Drag n drop Material# into ROW area Drag n drop Size into COLUMN area Drag n drop Size into DATA area (it'll appear as Count) Click OK Finish. That's it Hop over to the pivot sheet (just to the left) where you'd find the full summary table that's desired: Unique Material# items listed down the left col, Unique Size items listed across the row, and the respective counts of the sizes for each Material-Size combination at the intersections -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Jon" wrote: I have two columns, E&D. E has a material number and D has the size. There is more than one size for one material. What I want to do is count the number of size base one size and material. For example: Material# size 1 1 2 2 2 1 1 3 2 1 3 4 Summary: Material # size count 1 1 1 2 1 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count with multiple criteria based on cell not blank? | Excel Worksheet Functions | |||
COUNT based on 2 criteria | Excel Worksheet Functions | |||
Count based on criteria | Excel Discussion (Misc queries) | |||
Using COUNTIF to count based on multiple cell criteria. | Excel Worksheet Functions | |||
Count or Sum based on more than 1 criteria | Excel Worksheet Functions |