In my linked sample file, the first sheet is where I figured out how to count values in a range based on dates in another column but now in the second sheet I'm trying to accomplish the same but instead of counting number values I want to count instances of words down the range. Anyone know the solution for this? Thanks
Last edited by juntjoo; 01-05-2017 at 11:33 AM.
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
Many contributors do not like to open files from 3rd-party sites, and it is quite easy to attach files to one of your posts on this site, so it would help if you attached a sample Excel workbook here.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Note that the Paperclip icon does not work.
Pete
Got it. Thanks
You can use the following formulae in the cells stated:
E2: =COUNTIFS(Table14[unique characters],D2,Table14[entry date],">="&TODAY()-7)
F2: =COUNTIFS(Table14[unique characters],D2,Table14[entry date],">="&TODAY()-30)
G2: =COUNTIFS(Table14[unique characters],D2,Table14[entry date],">="&TODAY()-90)
H2: =COUNTIFS(Table14[unique characters],D2)
Then copy down to the bottom of your table.
Hope this helps.
Pete
thank you. worked out great.
Glad to help - thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks