So I am wanting to do a count of a problem but in the list (column A) which will eventually be really long and never the same thing all the time. In column C, I have the specific problem I want to count that problem. In column E I have manually counted how many there are. Let me know if this is possible. Thanks in advance!
Last edited by ncurran217; 03-28-2012 at 04:03 PM. Reason: Solved
ncurran217,
In cell D2 and copied down:
=COUNTIF(A:A,"*"&C2&"*")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks