Thread
:
Can I add a range and then divide that sum by a specific value?
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Gordon Shumway
external usenet poster
Posts: 5
Can I add a range and then divide that sum by a specific value?
On Thu, 13 Dec 2012 19:25:45 -0800 (PST),
wrote:
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
The answer was so simple and I was trying to make it complicated. This
works.
Thank you.
Reply With Quote
Gordon Shumway
View Public Profile
Find all posts by Gordon Shumway