i need to make a tally

P

paul_88

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

Mark

paul_88 said:
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.
 
Top