yorkshirelad
Board Regular
- Joined
- Aug 18, 2003
- Messages
- 100
Hi Guys - I can do this but I'm sure there's a simpler solution. I just need to sum a column giving each cell a value of 1 if it has a text entry.
So I have entries in cells (C8:C16) if there are three cells with text entries I'd like the sum to be 3. Your thoughts would be very appreciated.
At the moment I'm considering an IF statement and believe there is an ISTEXT type solution. Any help would be much appreciated.
Many thanks
Yorkshirelad
So I have entries in cells (C8:C16) if there are three cells with text entries I'd like the sum to be 3. Your thoughts would be very appreciated.
At the moment I'm considering an IF statement and believe there is an ISTEXT type solution. Any help would be much appreciated.
Many thanks
Yorkshirelad