I am trying to add up different categories in a spread sheet to find out how people heard of our facility. So, we have 11 different categories that people choose from that include Friends / Family, Word of Mouth, Swim Meet, etc... With over 400 different people in the spread sheet I don't want to count each an every one.
How do I create an equation that will count the number of times a given phrase comes up?
Thanks in advance
Last edited by garrettw731; 09-13-2010 at 10:18 AM.
Thanks for taking the time to read and comply with the rule.
=COUNTIF(A$1:A$400,"Word of Mouth"). You can replace the text with a cell reference.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks