Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula syntax {;;;}
HI,
I have a formual {=sum(if.......)} when I try to edit the formula, the { } disapear and the formula no longer works. If I type these characters in, it still does not work. What do they ( { } )mean ? |
#2
|
|||
|
|||
Hi Simplefi
This is a array formula You must use Ctrl-Shift-Enter See http://www.cpearson.com/excel/array.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Simplefi" wrote in message ... HI, I have a formual {=sum(if.......)} when I try to edit the formula, the { } disapear and the formula no longer works. If I type these characters in, it still does not work. What do they ( { } )mean ? |
#3
|
|||
|
|||
it means it is an array formula. When you edit it enter it using
controshift-enter it will then do the calcs and th{} will come back "Simplefi" wrote: HI, I have a formual {=sum(if.......)} when I try to edit the formula, the { } disapear and the formula no longer works. If I type these characters in, it still does not work. What do they ( { } )mean ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |