Can I add a range and then divide that sum by a specific value?
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. |
Can I add a range and then divide that sum by a specific value?
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 |
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. |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com