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
|