IF-ISTEXT formula

C

Cardian

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.
 
B

bj

this is an array formula enter it withsimultanious control-shift-enter
rather than just enter
 
R

Ron Rosenfeld

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
 
T

Toppers

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
 
H

Harlan Grove

Cardian said:
{=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.
 
C

Cardian

Ron Rosenfeld said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top