AFTER REPLACING FORMULA WITH VALUES, HOW DO I ADD THE COLUMN?

[dyfrog]

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!

 

[gjcase]

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

---GJ

 

[dyfrog]

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

Any other suggestions ?

 

[Bryan Hessey]

If you use Excel Help and search for 'small green triangle' it wil
display 'about triangle indicatos in cells' which states "A gree
triangle in the upper-left corner of a cell indicates an error in th
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

--

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

Any other suggestions ?

 

[Peo Sjoblom]

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

 

[Gord Dibben]

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