B BenjieLop Dec 21, 2005 #3 Smokey_Vol said: How can I give the total of how many times a word appears in a column? Click to expand... Assuming your column range is A1:A100, you can use this =COUNTIF(A1:A100,\"WORD_THAT_NEEDS_TO_BE_COUNTED\")[/B] OR IF THE WORD THAT YOU WANT TO COUNT IS, SAY, IN CELL B1, THE ABOVE FORMULA CAN BE MODIFIED TO BE =COUNTIF(A1:A100,\"*\"&B1&\"*\") Hope this is what you looking for. Regards.
Smokey_Vol said: How can I give the total of how many times a word appears in a column? Click to expand... Assuming your column range is A1:A100, you can use this =COUNTIF(A1:A100,\"WORD_THAT_NEEDS_TO_BE_COUNTED\")[/B] OR IF THE WORD THAT YOU WANT TO COUNT IS, SAY, IN CELL B1, THE ABOVE FORMULA CAN BE MODIFIED TO BE =COUNTIF(A1:A100,\"*\"&B1&\"*\") Hope this is what you looking for. Regards.
