Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
This is a new one.
Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
Well I just managed to figure this one out. One of the cells referenced
below was itself included in the range it summed, creating a circular reference. So XL couldn't sum it apparently. Dave -- Brevity is the soul of wit. "Dave F" wrote: This is a new one. Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
What do you get using =G10+G16+G37+G52+G127+G156+G178
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave F" wrote in message ... This is a new one. Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
So tell why you used =SUM(G10+G16+G37+G52+G127+G156+G178)
rather than =G10+G16+G37+G52+G127+G156+G178 I know they are only equivalent if all cells contain numeric values. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave F" wrote in message ... Well I just managed to figure this one out. One of the cells referenced below was itself included in the range it summed, creating a circular reference. So XL couldn't sum it apparently. Dave -- Brevity is the soul of wit. "Dave F" wrote: This is a new one. Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
No reason why I use =SUM(G10+...+G178)
It gives the same answer as what you have below. Dave -- Brevity is the soul of wit. "Bernard Liengme" wrote: What do you get using =G10+G16+G37+G52+G127+G156+G178 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave F" wrote in message ... This is a new one. Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM function???
I think most people who use =sum(), use a comma to separate the arguments:
=sum(g10,g16,g37) or drop the sum and use =g10+g16+g37 But wrapping g10+g16+g37 with =sum() doesn't do anything helpful. Dave F wrote: No reason why I use =SUM(G10+...+G178) It gives the same answer as what you have below. Dave -- Brevity is the soul of wit. "Bernard Liengme" wrote: What do you get using =G10+G16+G37+G52+G127+G156+G178 best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dave F" wrote in message ... This is a new one. Using the SUM function in XL 2003 to sum up a series of cells: =SUM(G10+G16+G37+G52+G127+G156+G178) All of these cells have values in them, which are themselves sums of other ranges. All cells in this formula are themselves calculating correctly, however, this formula is resolving to 0 (all calculations in the cells above are positive, so 0 is mathematically impossible.) Calculation is set to automatic, there are no links to external web sites and the cells referenced above, are formatted as currency. Thoughts? -- Brevity is the soul of wit. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |