Your question can best be answered by uploading an example workbook that meets the following criteria:

1. It EXACTLY duplicates the structure of your real workbook, AND
2. It contain representative but non-sensitive dummy data, AND
3. It contains a few examples of the desired results shown manually and the basic logic explained.

For your purposes, are the awards cumulative or just a flat amount for each milestone?