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
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing margins on 2nd page of letterhead template 4
Merging from an Excel file with graphics 1
Grouping {MERGEFIELD} into 2 or 3 Columns 0
how to get a warning when data is entered wrongly 12
Descenders clipped 0
Autonumber field in Excel that behaves the same as Access 0
How can the font and size of (all) citation numbers be altered? 1
Dealing with a Pivot Table (when I don't want to) 0

Top