Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
I downloaded a template from Office.com that runs a formula across a ROW.
I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
This is an array formula. Use Ctrl+Shift+Enter.
-- "Cardian" wrote in message ... I downloaded a template from Office.com that runs a formula across a ROW. I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
this is an array formula enter it withsimultanious control-shift-enter
rather than just enter "Cardian" wrote: I downloaded a template from Office.com that runs a formula across a ROW. I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
On Mon, 6 Aug 2007 08:40:02 -0700, Cardian
wrote: I downloaded a template from Office.com that runs a formula across a ROW. I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. This is an **array** formula. From HELP: EDIT AN ARRAY FORMULA Click the cell that contains the array formula. Click in the formula bar . When the formula bar is active, the braces ({ } ) do not appear in the array formula. Edit the array formula. Press CTRL+SHIFT+ENTER. --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
Type the formula as below
=SUM(IF(ISTEXT(D34:AZ34),1,0)) Enter with Ctrl+Shift+Enter which will place the {} brackets round the formula. This is an *array formula* and Excel adds the {} brackets for this type of formula. You need to enter in the same way if you amend the formula. HTH "Cardian" wrote: I downloaded a template from Office.com that runs a formula across a ROW. I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-ISTEXT formula
"Cardian" wrote...
.... {=SUM(IF(ISTEXT(D34:AZ34),1,0))} .... This is an array formula. Excel itself adds the braces when you enter it by holding down [Ctrl] and [Shift] keys before pressing the [Enter] key. That said, don't bother with this formula. Use =COUNTIF(D34:AZ34,"*") instead. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
THANK YOU TO ALL!!
"Ron Rosenfeld" wrote: On Mon, 6 Aug 2007 08:40:02 -0700, Cardian wrote: I downloaded a template from Office.com that runs a formula across a ROW. I've tried repeatedly to copy the formula (even retyped it) to run down a COLUMN, with no luck.......help would be greatly appreciated. I've confirmed that the values within the referenced cells are text. {=SUM(IF(ISTEXT(D34:AZ34),1,0))} Every time I try to edit the formula, the outside brackets disappear. If I try to manually type them in, the formula presents as text, instead of a formula. This is an **array** formula. From HELP: EDIT AN ARRAY FORMULA Click the cell that contains the array formula. Click in the formula bar . When the formula bar is active, the braces ({ } ) do not appear in the array formula. Edit the array formula. Press CTRL+SHIFT+ENTER. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISTEXT TRUE then copy formula from cell X | Excel Worksheet Functions | |||
How can I nest ISTEXT and IF functions? | Excel Worksheet Functions | |||
Excel expression {=SUm(if(istext(c8:k8),1,0))} | Excel Worksheet Functions | |||
ISTEXT | Excel Discussion (Misc queries) | |||
I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) |