ExcelBanter - Excel expression {=SUm(if(istext(c8:k8),1,0))}

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel expression {=SUm(if(istext(c8:k8),1,0))} (https://www.excelbanter.com/excel-worksheet-functions/49814-excel-expression-%7B%3Dsum-if-istext-c8-k8-1-0-%7D.html)

Mike

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

Shatin

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

Mike

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

All times are GMT +1. The time now is 06:19 AM.