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. |
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. |
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. |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com