View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default 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