+ Reply to Thread
Results 1 to 3 of 3

Calculate number of occurrences of text in the past 12 months

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    St Louis MO
    MS-Off Ver
    2013
    Posts
    3

    Calculate number of occurrences of text in the past 12 months

    I have looked around here and am not seeing something already answering my question, so if I have missed out on the answer, I apologize.

    I have a spreadsheet that has column A containing dates that data was entered going back as much as 3 years.
    Column B has a list of results, such as "pass" fail" or "discontinued" in it.
    What I am trying to do is create a cell or cells that will automatically look back over the past 12 months in column A from today (not from the latest entry, but from today) and tell me how many of those entries in column B have the word "pass", another will tell me how many have the word "fail", etc.
    In other words, can someone help me with the formula that will count the occurrences in column B in the past 12 months in column A from today?

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Calculate number of occurrences of text in the past 12 months

    Hello
    Perhaps Countifs for example:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Pass, Fail etc could be a cell reference rather than hard coded as here.

    DBY
    Last edited by DBY; 07-01-2015 at 02:55 PM. Reason: typo

  3. #3
    Registered User
    Join Date
    07-01-2015
    Location
    St Louis MO
    MS-Off Ver
    2013
    Posts
    3

    Re: Calculate number of occurrences of text in the past 12 months

    That did the trick.
    Thanks so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count the number of occurrences of a particular item in the past 365 days.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2015, 03:45 PM
  2. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  3. [SOLVED] Calculate Number of Months
    By xybadog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2013, 05:55 AM
  4. [SOLVED] Calculate total dollar amount the is past the past due date
    By Barb1980 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-12-2012, 05:34 PM
  5. How to calculate past rent due in months
    By noviceone in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-25-2012, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1