LinkBack URL
About LinkBacks
In Excel 2007 I want to count the number of times a certain text string appears in a column and have that number appear in a different worksheet. What formula do I use? Thanks
CPT Adam T. Bradford
US Army
In Excel 2007 I want to count the number of times a certain text string appears in a column and have that number appear in a different worksheet. What formula do I use? Thanks
CPT Adam T. Bradford
US Army
Hello Adam, If you want to count "text" in column A of "my worksheet" try this formula
=COUNTIF('my worksheet'!A:A,"text")
Audere est facere
Hi,
Give COUNTIF a try.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thank you very much daddylonglegs, worked like a charm! I appreciate your timely and accurate response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks