G Guest Aug 10, 2006 #1 i have a table that has cells in colimns that display letters, for every 'k' i need to add 1 to a total
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 Aug 10, 2006 #2 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.
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.
