Want to make sure I understand...

... if I enter this formula:

=AVERAGE('SPARE 1:SPARE 6'!H16)

I get a result, even if all H16 cells are 0... I get 0....

Am I misunderstanding you?