i need to make a tally

's Computer Specifications

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

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how does one tally numbers as in word xp. ie tally above	=?Utf-8?B?ZGF2ZTA=?=	Microsoft Word New Users	1	23rd Jun 2006 05:53 AM
How can I tally duplicate values (tally names) within a table..	=?Utf-8?B?SmE=?=	Microsoft Access Queries	2	2nd May 2006 10:52 PM
create tally sheet for positions- insert names and tally #	=?Utf-8?B?dGFsbHkgc2hlZXRz?=	Microsoft Excel Misc	0	11th Apr 2006 10:41 PM
how do i make tally for bridge games	=?Utf-8?B?YnJpZGdlIHRhbGxpZXM=?=	Microsoft Word New Users	3	27th Mar 2006 08:47 PM
how do i make a tally chart in excel?	=?Utf-8?B?c3RlcGhfd2FsZXM=?=	Microsoft Excel Charting	0	4th Oct 2005 04:51 PM