[SOLVED] COUNTA Formula not working

[Scudo]

I have the following in cell A60 It is used to add the amount of entries in
the column A. It used to give me a total in A60 but for some reason now
gives me the formula. have I done something I shouldnt have?

=COUNTA(A3:A59)

[Niek Otten]

The cell was formatted as text before you entered the formula.
Format as General and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten

"Scudo" <[email protected]> wrote in message
news:[email protected]...
>I have the following in cell A60 It is used to add the amount of entries in
> the column A. It used to give me a total in A60 but for some reason now
> gives me the formula. have I done something I shouldnt have?
>
> =COUNTA(A3:A59)
>
>

[David McRitchie]

check this thread: probably formatted as text, but other possibilities exist
http://groups.google.com/groups?thre...oglegroups.com

"Scudo" <[email protected]> wrote in message news:[email protected]...
> I have the following in cell A60 It is used to add the amount of entries in
> the column A. It used to give me a total in A60 but for some reason now
> gives me the formula. have I done something I shouldnt have?
>
> =COUNTA(A3:A59)
>
>

[Paul B]

Scudo, is this the only formula on the sheet? or are all the formulas this
way, try Ctrl+`, next to the number 1 key and see if that changes it back,
or maybe the cell may have somehow chaged to text, select the cell and see,
if it is change the formatting back to general, or a number, select the cell
press F2 then enter and see if that will fix it

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Scudo" <[email protected]> wrote in message
news:[email protected]...
> I have the following in cell A60 It is used to add the amount of entries
in
> the column A. It used to give me a total in A60 but for some reason now
> gives me the formula. have I done something I shouldnt have?
>
> =COUNTA(A3:A59)
>
>

[Scudo]

Thanks for reply,

I re formatted the cell A60 as `general` but it is still displaying the
formula rather than the result.


"Niek Otten" <[email protected]> wrote in message
news:#[email protected]...
> The cell was formatted as text before you entered the formula.
> Format as General and re-enter the formula (F2, ENTER)
>
> --
> Kind regards,
>
> Niek Otten
>
> "Scudo" <[email protected]> wrote in message
> news:[email protected]...
> >I have the following in cell A60 It is used to add the amount of entries
in
> > the column A. It used to give me a total in A60 but for some reason now
> > gives me the formula. have I done something I shouldnt have?
> >
> > =COUNTA(A3:A59)
> >
> >
>
>

[Niek Otten]

did you re-enter the formula? and try the other suggestions you got?
--
Kind regards,

Niek Otten

"Scudo" <[email protected]> wrote in message
news:[email protected]...
> Thanks for reply,
>
> I re formatted the cell A60 as `general` but it is still displaying the
> formula rather than the result.
>
>
> "Niek Otten" <[email protected]> wrote in message
> news:#[email protected]...
>> The cell was formatted as text before you entered the formula.
>> Format as General and re-enter the formula (F2, ENTER)
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Scudo" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have the following in cell A60 It is used to add the amount of entries
> in
>> > the column A. It used to give me a total in A60 but for some reason now
>> > gives me the formula. have I done something I shouldnt have?
>> >
>> > =COUNTA(A3:A59)
>> >
>> >
>>
>>
>
>

[Scudo]

Yes I tried that and also (tools, option, calculation, automatic/manual)
in case I had changed something in there.
When I change to `general` and re enter the formula (it displays the
formula) I then go back to format it is still formatted for general so it
doesnt appear to be defaulting back to text.

"Niek Otten" <[email protected]> wrote in message
news:#[email protected]...
> The cell was formatted as text before you entered the formula.
> Format as General and re-enter the formula (F2, ENTER)
>
> --
> Kind regards,
>
> Niek Otten
>
> "Scudo" <[email protected]> wrote in message
> news:[email protected]...
> >I have the following in cell A60 It is used to add the amount of entries
in
> > the column A. It used to give me a total in A60 but for some reason now
> > gives me the formula. have I done something I shouldnt have?
> >
> > =COUNTA(A3:A59)
> >
> >
>
>

[Niek Otten]

especially this one

try Ctrl+`,


--
Kind regards,

Niek Otten

"Scudo" <[email protected]> wrote in message
news:%[email protected]...
> Yes I tried that and also (tools, option, calculation, automatic/manual)
> in case I had changed something in there.
> When I change to `general` and re enter the formula (it displays the
> formula) I then go back to format it is still formatted for general so it
> doesnt appear to be defaulting back to text.
>
> "Niek Otten" <[email protected]> wrote in message
> news:#[email protected]...
>> The cell was formatted as text before you entered the formula.
>> Format as General and re-enter the formula (F2, ENTER)
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Scudo" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have the following in cell A60 It is used to add the amount of entries
> in
>> > the column A. It used to give me a total in A60 but for some reason now
>> > gives me the formula. have I done something I shouldnt have?
>> >
>> > =COUNTA(A3:A59)
>> >
>> >
>>
>>
>
>

[Linda]

Hi,

Try Tools-Options-View Tab. Look under Window Options on that tab. Is the
check box for formulas selected? If so, deselect.
--
Linda



"Scudo" wrote:

> I have the following in cell A60 It is used to add the amount of entries in
> the column A. It used to give me a total in A60 but for some reason now
> gives me the formula. have I done something I shouldnt have?
>
> =COUNTA(A3:A59)
>
>
>