try countif. =countif(a1:a100,"a")
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Zilla" wrote:

I need a sum formula for the following. in the first column is the
letters and the second is the reason. at the bottom i would like a
total of how many "A's" there were B's, C's etc. So if i type the
letter C in the right column it would add one to the total and make it
5. Here is a link to the example. any help would be great.
thanks



A = 4
B = 2
C = 4


http://img401.imageshack.us/img401/5587/codebg0.jpg