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.

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.

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.

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.

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.

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