Excel Formula and Function across multiple worksheets

[dfeagans]

Good Evening,

I am just an average excel user. I can usually feel my way through or research how to do something, but this spreadsheet has me beat. I need some help.

I have 24 worksheets in the entire workbook. The worksheets are an instructions, summary, start, 20 worksheets (employee 1- 20), and an end worksheet. The summary worksheet is what Im needing help with.

In the 20 worksheets I have 2 columns that require data entry. Column D is for the date an item was issued. Column E is when that item was completed. These worksheets also have 1 column (column F) with a data of how many days it took to complete the issued work.

I researched and found to create a "start and end" worksheet and that seemed to work, however, I do not want start and end to be used because the worksheets will eventually be renamed with an employee name.

In the summary worksheet, I have 3 columns that I want to reveal data. Column C I want to reveal the average day in training. I want this to take all 20 worksheet (employee 1 through employee 20) and average all those days in column F. I have two problems with this. I don't want start and end being used and not all 20 worksheets will be used, so if the "0" will be included in the average, then it will skew the average.

In these 3 columns on the summary worksheet, I also have 1 column showing the min days (column D) and the max days (Column E). The min day seems to be picking up "0", however, I do not want "0" to be included" So this formula is incorrect. The max column, column E, is correct and working properly.

Can anyone help with the average and the min column?

[FDibbins]

the nice thing about using a "start" and "end" worksheet range for summarizing multiple sheets, is that you can change the sheet names inside those 2 as much as you want, it wont make any difference. and if you have sheets inside that you wont be using, just drag them outside range, and they wont be included in any calcs - likewise, you can add more sheets just by dragging them inside the range