adding non-adjacent cells depending on another cell

Clayton,

As I suggested earlier a sample worksheet with a few data in a zipped format would make it much easier to give you a precise answer ...

HTH
Carim