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