Excel Programming for Sales Pipeline Report

I have an existing Sales Pipeline report (attached to this project) and I need formulas created to organize and sum the data. We are currently using a combination of SUMIF and SUMPRODUCT formulas, but VLOOKUP-related formulas may be needed. Right now we have to manually adjust ranges to make the forumlas work whenever the data changes. The attached xlsx file shows yellow highlights in the areas I need formulas created. The work to be done is: 1. Modify all formulas in columns named "Expected" so that the forumula automatically finds and calculates lines from source table that match the "Stage" for that row. 2. Calculate "Forecast Project" row, by month, using instructions highlighted in yellow on this line 3. Calculate "Forecast MRR" row, by month, using instructions highlighted in yellow on this line 4. Calculate "Forecast WS + SVR" row, by month, using instructions highlighted in yellow on this line These instructions are easier to understand when you look at the spreadsheet. Please ask me if anything is unclear. Thanks!