Hello,
I have 14 worksheets in my current workbook, 13 of which are different employees. Each day I am entering data that is then automatically averaged into a mtd column. Sometimes there will be 0's in those mtd columns and I dont want those counted when i take the number from the single cell on all of the worksheets to produce a correct average on sheet 14 Please help i've been working on this for 3 days. Here is a list of different formulas Ive tried.

=SUM(sheet1:sheet13!B2)/COUNTIF(sheet1!B2,"0",sheet2,"0",sheet3,"0",she et4,"0",sheet5,"0",sheet6,"0",sheet7,"0",sheet 8,"0",sheet9,"0",sheet10,"0",sheet11,"0",sheet 12,"0",sheet13,"0")

=AVERAGE(IF(sheet1:sheet13!B2<0,sheet1:sheet13!B2, "")

And other variations of those....either I get a REF or VALUE error when doing this. Ive searched and searched the last 3 days and im about to give up. Please help