I'm a self-learning, fairly newbie to Excel and need some help with this formula. I have a project going whereby my team members need to make 10 outgoing phone calls per day. At the end of the day, I will input the actual amount of calls they made into the spreadsheet and would like the next cell to calculate plus/minus from that daily quota and keep a running count over the next 60 days. The sheet will look like this:
Cell A2 thru A60 is the Date
Cell B2 thru B60 is the Daily Quota of 10
Cell C2 thru C60 is the Calls Made (let's put 17 in C2)
Cell D2 thru D60 is Plus/Minus Quota
What is the formula to enter into D2 and can I simply drag that formula down to D60?
Thank you in advance for any help someone can provide!
Bookmarks