If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
COUNTA Formula not working
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) |
#2
|
|||
|
|||
COUNTA Formula not working
check this thread: probably formatted as text, but other possibilities exist
http://groups.google.com/groups?thre...oglegroups.com "Scudo" wrote in message . uk... 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) |
#3
|
|||
|
|||
COUNTA Formula not working
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" wrote in message . uk... 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) |
#4
|
|||
|
|||
COUNTA Formula not working
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" wrote in message . uk... 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) |
#5
|
|||
|
|||
COUNTA Formula not working
Thanks for reply,
I re formatted the cell A60 as `general` but it is still displaying the formula rather than the result. "Niek Otten" wrote in message ... 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" wrote in message . uk... 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) |
#6
|
|||
|
|||
COUNTA Formula not working
did you re-enter the formula? and try the other suggestions you got?
-- Kind regards, Niek Otten "Scudo" wrote in message . uk... Thanks for reply, I re formatted the cell A60 as `general` but it is still displaying the formula rather than the result. "Niek Otten" wrote in message ... 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" wrote in message . uk... 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) |
#7
|
|||
|
|||
COUNTA Formula not working
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" wrote in message ... 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" wrote in message . uk... 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) |
#8
|
|||
|
|||
COUNTA Formula not working
especially this one
try Ctrl+`, -- Kind regards, Niek Otten "Scudo" wrote in message .uk... 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" wrote in message ... 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" wrote in message . uk... 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) |
#9
|
|||
|
|||
COUNTA Formula not working
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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Array formula not working | Alex | Worksheet Functions | 3 | June 15th, 2005 12:28 AM |
Array formula not working properly | Jack Schitt | General Discussion | 14 | September 4th, 2004 07:32 PM |
Array Entered formula not working fine | Vasant Nanavati | Worksheet Functions | 4 | May 8th, 2004 12:23 PM |
Converting a SUMPRODUCT formula to COUNTA active... | BeSmart | Worksheet Functions | 8 | March 27th, 2004 03:36 PM |
array formula not working | Scruff57 | Worksheet Functions | 7 | January 15th, 2004 04:46 PM |