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.
By the way, you can disregard the instructions (steps 1-12) in the spreadsheet, those are instructions for the salesperson who will enter data into the form.
Được trao cho:
Dear Hiring Manager, I want to do this "Excel Programming for Sales Pipeline Report" project now, let's start immediately. I have read the job description. Regards, Oliver
37 freelancer đang chào giá trung bình $42 cho công việc này
I can handle this project. I am a branch specialist in the bank where i am connected with and i used to work with advance office applications like MS excel. Let's get it done Sir/Madam!!!