please give some examples

What exactly do you want?

2
3
0
0
0

="Grand total equals "&sum(A1:a5)
would give you a cell displaying "Grand total equals 5"

If you want a total of words in a column, say "cat"
=COUNTIF(A1:A5,"cat")
would tell you how often the word "cat" appears. (0)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gangadhar" wrote:

please give some examples

You mean like 3333.33 should be

Three Thousand Three Hundred And Thirty Three Dollars And Thirty three Cents

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Thu, 11 Dec 2008 12:06:08 -0800, gangadhar
wrote:

please give some examples