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: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528373

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 editpaste 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 toolsoptionscalculation


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"dyfrog" wrote in message
...
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

--

dyfrog 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




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
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 EditCopy.

Select your range of data and Paste SpecialAddOKEsc to coerce the data to
Numbers.


Gord Dibben MS Excel MVP

On Wed, 5 Apr 2006 15:43:03 -0700, dyfrog
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