Home Forums Tech Helproom Sort Columns of Letters Excel 2007 Forum Rules | Contact Forum Editor | Report a Post Sort Columns of Letters Excel 2007 tonyq 14:20 25 Nov 2012 Locked Hi all, I have 3 columns of letters ranging from A to L in a spread sheet. Is there a way to tell me how many of each letters there are. Zak 14:24 25 Nov 2012 Use this formula in your chosen cell say C1: =COUNTIF(A1:A26,"A") then for C2 =COUNTIF(A1:A26,"B") and so on. tonyq 15:54 25 Nov 2012 I am wanting a list of the number of letters. I have managed to do it using Zak's suggestion. Thank you for your help. This thread is now locked and can not be replied to.