software

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--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528373Thank you gjcase, but the column is already formatted a NUMBER (not text) but
still wont SUM.

Any other suggestions ?

quot;gjcasequot; wrote:

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


If you use Excel Help and search for 'small green triangle' it will
display 'about triangle indicatos in cells' which states quot;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.quot;

Perhaps this could resolve your problem

--

dyfrog Wrote:
gt; Thank you gjcase, but the column is already formatted a NUMBER (not
gt; text) but
gt; still wont SUM.
gt;
gt; Any other suggestions ?
gt;
gt; quot;gjcasequot; wrote:
gt;
gt; gt;
gt; gt; Make sure you have numbers vs text. There are numerous posts in
gt; this
gt; gt; forum on this subject. (Youn can test using ISTEXT)
gt; gt;
gt; gt; ---GJC
gt; gt;
gt; gt;
gt; gt; --
gt; gt; gjcase
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; gjcase's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26061
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=528373
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=528373that 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 editgt;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 toolsgt;optionsgt;calculation--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;dyfrogquot; gt; wrote in message
...
gt; Thank you gjcase, but the column is already formatted a NUMBER (not text)
gt; but
gt; still wont SUM.
gt;
gt; Any other suggestions ?
gt;
gt; quot;gjcasequot; wrote:
gt;
gt;gt;
gt;gt; Make sure you have numbers vs text. There are numerous posts in this
gt;gt; forum on this subject. (Youn can test using ISTEXT)
gt;gt;
gt;gt; ---GJC
gt;gt;
gt;gt;
gt;gt; --
gt;gt; gjcase
gt;gt; ------------------------------------------------------------------------
gt;gt; gjcase's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=26061
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=528373
gt;gt;
gt;gt;
Simply formatting the cells as Number is not sufficient if Excel believes they
are text.

Select an empty cell formatted as Number and Editgt;Copy.

Select your range of data and Paste Specialgt;Addgt;OKgt;Esc to coerce the data to
Numbers.Gord Dibben MS Excel MVP

On Wed, 5 Apr 2006 15:43:03 -0700, dyfrog gt;
wrote:

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