| Home |
| Search |
| Today's Posts |
|
#5
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 |
| 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) | |||
Threaded Mode
