Hi Guys,
I hope that you are all well!
I wondered if there are any Excel Formula Gods/Goddesses out there….
I have tried to find the answer with the threads in this forum with no avail, so please forgive me if this question has been answered before.
In my workbook I have several Worksheets.
Each Worksheet represents a working week for Employees
Within this, I manually enter the days that they have worked (Monday-Friday) with the number of sales made that day (actual number not a money figure).
Name Mon Tues Wed Thurs Fri
Employee 1 0 4 6 1
Employee 2 7 3 0 8 5
Employee 3 1 3 0
Employee 4 5 0 9 2
Employee 5 0 8 0 7
There are some cells which do not have a figure due to the person not working that day
As you can see, based on the above figures;
Employee 1
Worked 4 days
Employee 2
Worked 5 days
Employee 3
Worked 3 days
Employee 4
Worked 4 days
Employee 5
Worked 4 days
I am trying to calculate the following formula:
The number of sales made over the last 10 “shifts” worked - where the value of 0 or more is entered (not 10 “days” in total). I believe I would use a formula based on the previous worksheet name.
Any help would be much appreciated.
Thankings you!
Bookmarks