Im trying to put together a formula that counts the specific # of times a certain word pops up in a range of cells.
I've been using Countif function and its so far been working when I type in quotes the word I want to count, however, it'd be great if I can link to a cell with the text and drag n drop so I dont have to reenter each word Im trying to count.
Hope that makes sense. Please see attached if interested for example. Thanks!
Do you mean in B22 and copy down?
=COUNTIF($A$2:$N$18, A21)
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.
instead of...=COUNTIF($A$2:$N$18, "DDR")
use this .....=COUNTIF($A$2:$N$18, A21)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Do u know how toextend the range across non-continuous cells? E.g. say I wanna count all cells in A1:A10 and C1:C10, excluding column B. Is that possible with a Countif Formula?
Haha wow now I feel smartThanks for pointing out! Works great now.
As you use Excel 2010, take a look to COUNTIFS function.
Or in SUMPRODUCT for All Excel versions.
FDibbins,
Kinda applied ur idea
=SUM(COUNTIF(A2:A10, A21),COUNTIF(C1:C10,A21))
Formula might've been lil different from above. But more or less that convention worked.
Thanks again!
Dom
knee-jerk answer...
=COUNTIF($A$2:$C$18, A21)-COUNTIF($B$2:$B$18, A21)
Not familiar with SUMPRODUCT, but Ill try that. Tried Countif, seems like that doesnt work for non-continuous cells.
Dom
Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
I would use the "Find" function and link to the range of cells I'm looking for.
If it doesn't find it, it will render an error.
Then I'd use the =IFERROR function to weed out the errors.
You'll have a list of the ones that match, and the ones that don't will be blank, or whatever value you've assigned in the iferror formula.
Moderators note: Please do not post links to commercial web sites. I have removed the link
Thanks
Last edited by FDibbins; 03-31-2013 at 01:14 AM.
@ Excel-Help.net,
THAT has got to be as close to a Rule 13 violation as I've seen in quite awhile..lol
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks