ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   i need to make a tally (https://www.excelbanter.com/new-users-excel/104238-i-need-make-tally.html)

paul_88

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

Mark

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.



All times are GMT +1. The time now is 11:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com