Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula in Excel 2003
I opened a spreadsheet that I have not used since I changed to Excel 2003.
When I try to copy a "sumif" created prior to Excel 2003, the formula is there but it does not calculate correctly. Also, when I "edit" the formula, I get the green triangle in the upper left corner of the cell. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula in Excel 2003
I found that if I "edit," and then pres shift control and enter at the same
time, that my formula will then calculate correctly. Is there something else I could do where I don't have to do this? "Ellen" wrote: I opened a spreadsheet that I have not used since I changed to Excel 2003. When I try to copy a "sumif" created prior to Excel 2003, the formula is there but it does not calculate correctly. Also, when I "edit" the formula, I get the green triangle in the upper left corner of the cell. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula in Excel 2003
Maybe you have manual calculation set, ToolsOptionsCalculation
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ellen" wrote in message ... I found that if I "edit," and then pres shift control and enter at the same time, that my formula will then calculate correctly. Is there something else I could do where I don't have to do this? "Ellen" wrote: I opened a spreadsheet that I have not used since I changed to Excel 2003. When I try to copy a "sumif" created prior to Excel 2003, the formula is there but it does not calculate correctly. Also, when I "edit" the formula, I get the green triangle in the upper left corner of the cell. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula in Excel 2003
"Ellen" wrote:
I found that if I "edit," and then pres shift control and enter at the same time, that my formula will then calculate correctly. Is there something else I could do where I don't have to do this? Pressing CTRL+SHIFT+ENTER (CSE) is the correct and only way to "enter"/confirm an array formula, which was probably what your formula was, albeit you didn't post your formula. If the CSE is correctly done, you should see Excel insert curly braces: { } around the formula, in the formula bar. Sight this as a visual check to ensure that the formula is correctly array-entered. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sumif formula in Excel 2003
On Feb 1, 6:47 pm, "Bob Phillips" wrote:
Maybe you have manual calculation set, ToolsOptionsCalculation -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ellen" wrote in message ... I found that if I "edit," and then pres shift control and enter at the same time, that my formula will then calculate correctly. Is there something else I could do where I don't have to do this? "Ellen" wrote: I opened a spreadsheet that I have not used since I changed to Excel 2003. When I try to copy a "sumif" created prior to Excel 2003, the formula is there but it does not calculate correctly. Also, when I "edit" the formula, I get the green triangle in the upper left corner of the cell. What is your formula? If it only works correctly with CSE then it would seem it is an array formula. Can you show us the formula in question? Kind regards, Matt Richardson http://teachr.blogspot.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif for groups and subgroups / Excel 2003 | Excel Worksheet Functions | |||
How do I use wildcard characters in Excel 2003 sumif formula? | Excel Worksheet Functions | |||
Getting Excel whilst using the sumif formula to search for part of a word | Excel Discussion (Misc queries) | |||
Formula in Excel--SUMIF | Setting up and Configuration of Excel | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |