I have 23 Worksheets in a workbook; all sheets are renamed and each is called
a person's name. All content is the same, but for the values in the charts.
From Sheet 1 I need to Average and/or Sum Each amount in cell "E8" on sheets
4-20, but only if it's 0. I've tried many variations, but none of them are
working.

any suggestions? If an example is provided can you also break down the
formula for me so I know where the numbers are coming from? Thank you for
your help.

Vree