I have a range that I have named ZeroRepeats. The range is 5 rows and 7 columns. I need to enter a formula into a cell (that is not in the range) to calculate the average of the 5 values in the first column of the ZeroRepeats range. Mostly, my problem is that I don't really know how to reference cells within my named range.

Thanks in advance!