If you can help figure this out, I would appreciate your help.

I am using this in a macro.
Col A is Division ( with Divisions numbers 1-100 but there is a random
number of lines for each division).
Col B is Amounts- debits and credits
Col C contains the number 1 in selected rows
Col D is a list of possible divisions 1-100 in numeric order
What I would like to do is the following:

Look at Column C and if there is a 1 in that cell, then sum the amounts from
Col B for each separate Division in Col A and put the sum in Col E beside the
corresponding division.
Thanks
Donna