Formulas in Excell 2007 nor working
 

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.

Formulas in Excell 2007 nor working
 

This means the cell is text formatted. One way round this...

Select column and use Data Text to columns Finish

"Mahmood" wrote:

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.

Formulas in Excell 2007 nor working
 

I don't use 2007 but in earlier versions this could mean you are in "Formula
View" or the cells were pre-formatted as Text.

If the latter, Re-format to General then on each cell, F2 and ENTER.


Gord Dibben MS Excel MVP

On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood
wrote:

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.

Formulas in Excell 2007 nor working
 

I tried to change the format of the cells but did not work. But going to
blank cell and changing their format to general before inserting formula
worked. Thanks.

"Gord Dibben" wrote:

I don't use 2007 but in earlier versions this could mean you are in "Formula
View" or the cells were pre-formatted as Text.

If the latter, Re-format to General then on each cell, F2 and ENTER.


Gord Dibben MS Excel MVP

On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood
wrote:

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.

Formulas in Excell 2007 nor working
 

Did you read all of my post?

I said you must re-enter the formulas after re-formatting.

That's what F2ENTER does.

Saves you re-typing the formulas.


Gord Dibben MS Excel MVP

On Sun, 13 Jul 2008 09:08:12 -0700, Mahmood
wrote:

I tried to change the format of the cells but did not work. But going to
blank cell and changing their format to general before inserting formula
worked. Thanks.

"Gord Dibben" wrote:

I don't use 2007 but in earlier versions this could mean you are in "Formula
View" or the cells were pre-formatted as Text.

If the latter, Re-format to General then on each cell, F2 and ENTER.


Gord Dibben MS Excel MVP

On Sun, 13 Jul 2008 08:36:01 -0700, Mahmood
wrote:

When I try to use any function like =SUM(C154:C163), =COUNTIF(D2:D137,"a")
etc instead of giving the result it simply shown the formula as above in the
cell.