Using scripting dictionary to do a sumifs

thanks.

Based on your code i also came up with a soln.

Basically you CAN NOT do this assignment and i dont know why:

dic_Ids.Item(ID_array(LC1, 1))(0) = LC1
      dic_Ids.Item(ID_array(LC1, 1))(1) = ProcA_array(LC1, 1)
      dic_Ids.Item(ID_array(LC1, 1))(2) = ProcB_array(LC1, 1)

but you CAN do this type of assignment:

dic_Ids.Item(ID_array(LC1, 1)) = Array(LC1, ProcA_array(LC1, 1), ProcB_array(LC1, 1))

i am also enclosing the code i came up with .........thanks again for your help.