L Luke M Dec 11, 2008 #2 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)
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)
G Gord Dibben Dec 12, 2008 #3 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
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
