my problem is almost exactly the same as the one listed here: https://www.excelforum.com/excel-for...orksheets.html
accept I will never have negative number so i dont need that part of the equation.
This formula works but only if there is a number filled in every cell, which wont always be the case: =AVERAGE('Employee 1'!O5:Q6,'Employee 2'!O5:Q6,'Employee 4'!O5:Q6,'Employee 5'!O5:Q6,'Employee 5'!O5:Q6,'Employee 6'!O5:Q6,'Employee 7'!O5:Q6,'Employee 8'!O5:Q6)
In a simpler part of the workbook, i found =AVERAGEIF(O5:Z6, ">0") fixed this issue but i understand AVERAGEIF doesnt work when your formula is pulling from multiple worksheets.
Can anyone give me formula that will give me the average of cells ('Employee 1'!O5:Q6,'Employee 2'!O5:Q6,'Employee 4'!O5:Q6,'Employee 5'!O5:Q6,'Employee 5'!O5:Q6,'Employee 6'!O5:Q6,'Employee 7'!O5:Q6,'Employee 8'!O5:Q6) without including the blank cells? I have been stuck for hours.
Please also explain your formula because I will need to recreate it with slightly different parts of the workbook.
Thanks
Bookmarks