Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum function
I am trying to add a column of numbers using the SUM function. The result
displayed is 0, but it should be much larger than this. |
#2
|
|||
|
|||
Did you use this formula, to select the entire column?
=SUM(D:D) "Confused" wrote: I am trying to add a column of numbers using the SUM function. The result displayed is 0, but it should be much larger than this. |
#3
|
|||
|
|||
What result do you get with:
=SUMPRODUCT(--Range) compared to: =SUM(Range) where Range is not a whole column reference? Confused wrote: I am trying to add a column of numbers using the SUM function. The result displayed is 0, but it should be much larger than this. |
#4
|
|||
|
|||
it is possible that excel is treating your numbers as text, to test this, in
another cell type =ISNUMBER(D1) where D1 is a number in the column you want to sum if FALSE is returned then you need to select a blank cell (probably on another worksheet) and choose copy then select your column and choose edit / paste special / add and click OK then reenter your SUM formula and it should work. Cheers JulieD "Beverly76" wrote in message ... Did you use this formula, to select the entire column? =SUM(D:D) "Confused" wrote: I am trying to add a column of numbers using the SUM function. The result displayed is 0, but it should be much larger than this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accessing a Function | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Function in XL or in VBA for XL that pulls numeric digits from a t | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |