LinkBack URL
About LinkBacks
I have a sheet named Passed. I need to add up how many times the word Streets is in column C and put it into cell B7 of a sheet named Chart. What is the best to go about this?
I have a sheet named Passed. I need to add up how many times the word Streets is in column C and put it into cell B7 of a sheet named Chart. What is the best to go about this?
=COUNTIF(Passed!$C$1:$C$10000,"*Streets*")Originally Posted by CityInspector
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Use COUNTIF function.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
RobertMika- That worked perfectly. Thanks!!
Last edited by CityInspector; 11-02-2012 at 11:12 AM. Reason: did not work at first but I realized my mistake
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks