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

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