| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cant calculate sum function
when i try to calculate the sum function on my worksheet it returns the
whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
Change the cell format to GENERAL.
It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
"Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
You need re-enter the formula after chaning the format. or just F2 and enter..
If this post helps click Yes --------------- Jacob Skaria "Neeraj Paul" wrote: "Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
"Jacob Skaria" wrote: You need re-enter the formula after chaning the format. or just F2 and enter.. If this post helps click Yes --------------- Jacob Skaria "Neeraj Paul" wrote: i did that too brother but it still doesnot work "Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
Might you be in "Formula View"?
From the Menu Bar, <Tools <Options <View tab, Under Window Options, make sure that "Formulas" is *unchecked*. Keyboard shortcut to toggle this: <Ctrl < ` with " ` " being the key (on my keyboard) under the <Esc key, and above the <Tab key, with the " ~ " on the same key. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Neeraj Paul" wrote in message ... "Jacob Skaria" wrote: You need re-enter the formula after chaning the format. or just F2 and enter.. If this post helps click Yes --------------- Jacob Skaria "Neeraj Paul" wrote: i did that too brother but it still doesnot work "Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
or press CTRL-` once
"Ragdyer" wrote: Might you be in "Formula View"? From the Menu Bar, <Tools <Options <View tab, Under Window Options, make sure that "Formulas" is *unchecked*. Keyboard shortcut to toggle this: <Ctrl < ` with " ` " being the key (on my keyboard) under the <Esc key, and above the <Tab key, with the " ~ " on the same key. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Neeraj Paul" wrote in message ... "Jacob Skaria" wrote: You need re-enter the formula after chaning the format. or just F2 and enter.. If this post helps click Yes --------------- Jacob Skaria "Neeraj Paul" wrote: i did that too brother but it still doesnot work "Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
I thought I said that.<g
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sheeloo" wrote in message ... or press CTRL-` once "Ragdyer" wrote: Might you be in "Formula View"? From the Menu Bar, <Tools <Options <View tab, Under Window Options, make sure that "Formulas" is *unchecked*. Keyboard shortcut to toggle this: <Ctrl < ` with " ` " being the key (on my keyboard) under the <Esc key, and above the <Tab key, with the " ~ " on the same key. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Neeraj Paul" wrote in message ... "Jacob Skaria" wrote: You need re-enter the formula after chaning the format. or just F2 and enter.. If this post helps click Yes --------------- Jacob Skaria "Neeraj Paul" wrote: i did that too brother but it still doesnot work "Sheeloo" wrote: Change the cell format to GENERAL. It must be TEXT now. "Neeraj Paul" wrote: when i try to calculate the sum function on my worksheet it returns the whole function in text like for eg: =sum(A1:A5) returns the same text =sum(A1:A5) and it does not calculate the figures. thanks in advance i did that but it still doesnot work |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
Yes, you did it and I missed that. Sorry.
"Ragdyer" wrote: I thought I said that.<g -- Regards, RD |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cant calculate sum function
I can't remember how many times I've failed to scroll down and read the rest
of the post.<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sheeloo" wrote in message ... Yes, you did it and I missed that. Sorry. "Ragdyer" wrote: I thought I said that.<g -- Regards, RD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function help to lookup and calculate the sum? | Excel Discussion (Misc queries) | |||
| Calculate function Xx+1=rX(1-X). How? | Excel Discussion (Misc queries) | |||
| function doesn't calculate | Excel Worksheet Functions | |||
| Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
| How to calculate PMT function | Excel Worksheet Functions | |||
Linear Mode
