Prev: Count If equals x AND y
Next: About Data Validation
From: Gary on 4 May 2010 22:59
can you make a sum a text insted of a number

From: trip_to_tokyo on 4 May 2010 23:26
EXCEL 2007

That depends upon what you want to do (you need to be more specific).

For example if cells G 5 to G 8 inclusive are filled with text then:-

=COUNTA(G5:G8) in cell G 9 returns the number 4.

If my comments have helped please hit Yes.




"Gary" wrote:

> can you make a sum a text insted of a number
>
From: ozgrid.com on 4 May 2010 23:33
http://www.ozgrid.com/VBA/ValueToWords.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Gary" <Gary(a)discussions.microsoft.com> wrote in message
news:9EFD9567-EAF1-48AC-94AA-98B119D9DE86(a)microsoft.com...
> can you make a sum a text insted of a number
>

 | 
Pages: 1
Prev: Count If equals x AND y
Next: About Data Validation