Help using Scripting Dictionary to sum values

hi,

I am enclosing an example macro to help explain what i am trying to do.

I thought the best approach is to use a scripting dictionary to do what i wanted but i am having problems implementing the code.

What i want to do:
On the sheet "Lookup_table" i have two cols of data. A uniquesubj value and the other col is just another designation for the same subj value.
On the sheet "ADMS_table" i have three cols of data. Col-A is a list of "uniquesubj" values similar to whats in col-A of the "Lookup_table" worksheet. In Col-B of the "ADMS_table" is a possible status value. Col-C on the "ADMS_Table" is a count of said status value. My goal is to reprodue the output shown on the worksheet "Output_results".

I am enclosing the code and information in the excel file.

If using a scripting dictionary is not the best way i am open to other alternatives.

Any help would be appreaciated.

thanks.

If you have any questions about anything just let me know and i will do my best to answer them.