On Thursday, December 13, 2012 5:24:09 PM UTC-8, Gordon Shumway wrote:
What I want to do is similar to an average but I don't want the number

of cells to have any relevance.



Thank you.

Try this where Data is a named range.

=SUM(Data)/8

Or this.

=SUM(F1:F9)/6

HTH
Regards,
Howard