Smokey_Vol said:
How can I give the total of how many times a word appears in a column?
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.
