| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
| Can I make formulas more flexible? | Excel Discussion (Misc queries) | |||
| How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Linear Mode
