Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Sometimes cells can retain text format if they have been formatted that way
previously, even if you later format them as numeric. Highlight all the number cells and press CTRL+1, check the format is set to number, then click OK and click on each of the cells in turn and press F2 followed by Enter to 're-enter' the numbers in the cells, they will now be formatted properly as numbers. Andrea Jones www.allaboutoffice.co.uk "SLP" wrote: Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Formatting does not make any difference once the entry is made. What do you
get when you try: =ISTEXT(<any cell in your range) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "SLP" wrote in message ... Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Hi,
Is there a green teriangle in the left top corner of the cells that your numbers are in them? if not please write your sum formula. Thanks, -- Farhad Hodjat "SLP" wrote: Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
If your data is in column A, rows 1-205, then in cell A206, type:
"=SUM(A1:A205)" (without the quotes) "SLP" wrote: Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Sounds like the entries are still text.
What happen with this formula =ISNUMBER(B2) where B2 is your first number? Do you get FALSE? Try this: Enter the number 1 in a cell; copy this cell Select the troubled values; use Edit | Paste Special and check Multiply This often gets text to turn to numbers (when possible, off course) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SLP" wrote in message ... Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Thanks for the response. I tried it but still no luck. Its almost time for
me to leave so tomorrow I will go into all the cells that lead into the cells that lead into the sum and do the same thing. "Andrea Jones" wrote: Sometimes cells can retain text format if they have been formatted that way previously, even if you later format them as numeric. Highlight all the number cells and press CTRL+1, check the format is set to number, then click OK and click on each of the cells in turn and press F2 followed by Enter to 're-enter' the numbers in the cells, they will now be formatted properly as numbers. Andrea Jones www.allaboutoffice.co.uk "SLP" wrote: Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Thanks for the repsonse. No triangle. (I'm a MOUS Master Instructor so know
about looking for the obvious.) Its just a simple : =sum(H205:H208) but doesn't want to work. "Farhad" wrote: Hi, Is there a green teriangle in the left top corner of the cells that your numbers are in them? if not please write your sum formula. Thanks, -- Farhad Hodjat "SLP" wrote: Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum not working
Bingo and Gold Star! I forgot about that one!!! Thanks a bunch.
"Bernard Liengme" wrote: Sounds like the entries are still text. What happen with this formula =ISNUMBER(B2) where B2 is your first number? Do you get FALSE? Try this: Enter the number 1 in a cell; copy this cell Select the troubled values; use Edit | Paste Special and check Multiply This often gets text to turn to numbers (when possible, off course) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SLP" wrote in message ... Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked Tools | Otpions -- Automatic is set. The cells leading into the =sum are formatted as numbers. (Also tried it with General). The cells that lead into those cells are not text. Any ideas on what is wrong? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=A(B2) isn't working | Excel Worksheet Functions | |||
I did have this working but I want to know how | Excel Discussion (Misc queries) | |||
Sum(if not working | Excel Discussion (Misc queries) | |||
Not working HELP | Excel Discussion (Misc queries) | |||
was working, now :( | Excel Worksheet Functions |