Can I add a range and then divide that sum by a specific value?

  • Thread starter Thread starter Gordon Shumway
  • Start date Start date
G

Gordon Shumway

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.
 
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.
Click to expand...

Try this where Data is a named range.

=SUM(Data)/8

Or this.

=SUM(F1:F9)/6

HTH
Regards,
Howard
 
Try this where Data is a named range.

=SUM(Data)/8

Or this.

=SUM(F1:F9)/6

HTH
Regards,
Howard
Click to expand...

The answer was so simple and I was trying to make it complicated. This
works.

Thank you.
 
Back
Top