Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel expression {=SUm(if(istext(c8:k8),1,0))}
This is an expression in an excel template. When I try to change the range
the {} disappear and the expression doesn't work. Why are the brackets there and why do they diappear? -- mike |
#2
|
|||
|
|||
This is an array formula that has to be entered by pressing
Ctrl+Shift+Enter. Read this article for details on array formulas. http://www.cpearson.com/excel/array.htm "Mike" wrote in message ... This is an expression in an excel template. When I try to change the range the {} disappear and the expression doesn't work. Why are the brackets there and why do they diappear? -- mike |
#3
|
|||
|
|||
thx!!
-- mike "Shatin" wrote: This is an array formula that has to be entered by pressing Ctrl+Shift+Enter. Read this article for details on array formulas. http://www.cpearson.com/excel/array.htm "Mike" wrote in message ... This is an expression in an excel template. When I try to change the range the {} disappear and the expression doesn't work. Why are the brackets there and why do they diappear? -- mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |