| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide one range with another | Excel Programming | |||
| Divide by the minimum non-zero number in a range of cells | Excel Worksheet Functions | |||
| Divide a range of cells by a number | Excel Discussion (Misc queries) | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Linear Mode
