My data is arranged as:
a b c d .......
aa8 ATWIL HOM 45.87 ...
aa8 ATWIL AUT 34.54 ...
aa8 ATWIL DFW 26.75 ...
bb9 BBQRE PKG 222.76 ...


I have already been able to sum the d column by column A in sheet 2. Now I
want to count the different codes in column B by column A. The key is I
don't want to count everything, but how many different codes there are in
column B for a particular code in column A.

All help is greatly appreciated.

Thanks

Cathy