| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I capture a text cell as a value to be able to sum?
I am trying to build a form in excel which requires the user to input TEXT in
a cell. I would like to sum the cells with the text to return a total number of entries. Each text has the same value of 1 in the sum. |
|
#2
|
|||
|
|||
|
Hi!
One way: =COUNTIF(A1:A100,"*") Biff "wallace37" wrote in message ... I am trying to build a form in excel which requires the user to input TEXT in a cell. I would like to sum the cells with the text to return a total number of entries. Each text has the same value of 1 in the sum. |
|
#3
|
|||
|
|||
|
Hi
Try this: =SUMPRODUCT((ISTEXT(E15:E23))*1) where your range is E15:E23. Andy. "wallace37" wrote in message ... I am trying to build a form in excel which requires the user to input TEXT in a cell. I would like to sum the cells with the text to return a total number of entries. Each text has the same value of 1 in the sum. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
| Moving text from one cell to another. | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
