I don't know how to explain, but I'll try

I have 5 worksheets (each of them being 8 columns x 52 rows... if this matters) with the first worksheet aggregating (totaling, averaging, etc.) data from the other 4.

Now, the secondary worksheets are fine and I can fiddle with them as I wish without running into any errors (probably because they don't need to aggregate data from other worksheets but only add,divide, etc. cells in their own selves).

But... the main worksheet is a bit tricky since it has to pull data from the other 4 sheets. Namely, I put this formula: =AVERAGE(F4:F52) (where f4:f52 are the rows I mentioned earlier) in one of the columns, in order to - obviously - get the average of all the 52 rows, where each row will calculate and pull the average from the other 4 worksheets. As I said, the formula above works like it should for the other worksheets, but for the main sheet it returns a #DIV/0 error. And the reason it returns this error is because some cells where the data is being pulled from have zeros. Which again is normal (since those cells really need to have zeroes). The problem is not that there are zeroes in those cells, but that I don't know the formula to automatically calculate averages just for the cells that have positive values (ignoring the cells with zeros in them).

If I could find out the formula to do this I would probably get rid of the #DIV/0 error too, but... I don't know that formula

Which is why I am asking here. Hopefully one of you handsome guys and gals (you ARE handsome, right?) understood my issue and wants to help me out. That would be so GREAT!

TIA and awaiting for your rescue