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!