View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mark Mark is offline
external usenet poster
 
Posts: 102
Default i need to make a tally


paul_88 wrote:
i have a table that has cells in colimns that display letters, for every 'k'
i need to add 1 to a total


Try something like this:

=COUNTIF(A1:A100,"k")

Change the A1:A100 to whatever your column is and the result of this
formula will be the number you want to add.