Hello All,
I am new here. This forum is AMAZING!
I am having issues with a particular formula. I have a daily sales tracking sheet for my staff and am looking for a way to calculate the amount of units per day I need in the current week to obtain the goal.
For example, if (hypathetically) someone worked 7 days and the goal was 7 (one per day) and we are about to start day 7 but only have 5 units, then the formula should reflect 2 units needed per day in this category to achieve the goal (2 units on the last day to make 7 total).
I've attached what I have so far. In this I have put in some random numbers just to test it out.
BP8 is the example goal.
BP9 should reflect "6" since there is one day that hasn't been filled in for this category and that is what is needed to achieve BP8 (ignore the formula that is currently in there).
How do I make this happen? As you can see, I will be copying and pasting this in several places, but I am lost. I am new to Excel, but am IN LOVE with it haha.
Thanks for all of your help that you've put into this forum!
Bookmarks