after replacing formula with values, how do i add the column?

I have a couple of columns, both of which are filled as a result of a
formula, as a formula I could not SUM the column. Therefore I replaced the
formula with the value, which has resulted in the small green triangle in the
top left hand corner of each cell. This still wont SUM or COUNT.

How can I get a total for these columns ?

THANK YOU!

Make sure you have numbers vs text. There are numerous posts in this forum on this subject. (Youn can test using ISTEXT)

---GJC

Thank you gjcase, but the column is already formatted a NUMBER (not text) but
still wont SUM.

Any other suggestions ?

"gjcase" wrote:

>
> Make sure you have numbers vs text. There are numerous posts in this
> forum on this subject. (Youn can test using ISTEXT)
>
> ---GJC
>
>
> --
> gjcase
> ------------------------------------------------------------------------
> gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
> View this thread: http://www.excelforum.com/showthread...hreadid=528373
>
>

If you use Excel Help and search for 'small green triangle' it will display 'about triangle indicatos in cells' which states "A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, Trace Error appears. Click the arrow next to the button for a list of options."

Perhaps this could resolve your problem

--

Originally Posted by dyfrog

Thank you gjcase, but the column is already formatted a NUMBER (not text) but
still wont SUM.

Any other suggestions ?

"gjcase" wrote:

>
> Make sure you have numbers vs text. There are numerous posts in this
> forum on this subject. (Youn can test using ISTEXT)
>
> ---GJC
>
>
> --
> gjcase
> ------------------------------------------------------------------------
> gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
> View this thread: http://www.excelforum.com/showthread...hreadid=528373
>
>

that has nothing to do with it, you should make sure the numbers are
formatted as numbers/general but you still might have force them to
calculate, copy an empty cell, select the numbers and do edit>paste special
and select add, if that does not work you must have trailing invisible
characters like html line feed (Chr 160) or spaces. the green triangle most
likely indicate that it is text numbers so the method copying a cell and
paste special selecting add should work. Also make sure you have
calculations set as automatic under tools>options>calculation


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"dyfrog" <[email protected]> wrote in message
news:[email protected]...
> Thank you gjcase, but the column is already formatted a NUMBER (not text)
> but
> still wont SUM.
>
> Any other suggestions ?
>
> "gjcase" wrote:
>
>>
>> Make sure you have numbers vs text. There are numerous posts in this
>> forum on this subject. (Youn can test using ISTEXT)
>>
>> ---GJC
>>
>>
>> --
>> gjcase
>> ------------------------------------------------------------------------
>> gjcase's Profile:
>> http://www.excelforum.com/member.php...o&userid=26061
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=528373
>>
>>

Simply formatting the cells as Number is not sufficient if Excel believes they
are text.

Select an empty cell formatted as Number and Edit>Copy.

Select your range of data and Paste Special>Add>OK>Esc to coerce the data to
Numbers.


Gord Dibben MS Excel MVP

On Wed, 5 Apr 2006 15:43:03 -0700, dyfrog <[email protected]>
wrote:

>Thank you gjcase, but the column is already formatted a NUMBER (not text) but
>still wont SUM.
>
>Any other suggestions ?
>
>"gjcase" wrote:
>
>>
>> Make sure you have numbers vs text. There are numerous posts in this
>> forum on this subject. (Youn can test using ISTEXT)
>>
>> ---GJC
>>
>>
>> --
>> gjcase
>> ------------------------------------------------------------------------
>> gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
>> View this thread: http://www.excelforum.com/showthread...hreadid=528373
>>
>>