how to count cell based on 2 Criteria

[Jon]

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

 

[Max]

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