Results 1 to 4 of 4

Count the word refrence for each date column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-30-2014
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    266

    Count the word refrence for each date column

    Hi
    I need help to find the formula on this attached file. The formula will be input in cell E6:I6. I need to count the number of times the status in column A shows up as "Damaged" for a card as I calculate on each date. However the status of the card can change as shown in the attached file. On the 24 may there is one damaged card. On the 25 may badge 2 has changed status to damaged. Expected results as shown on the attached file should be on the 24 may remain as 1 damaged card and on the 25 may it should show up as 2 damaged cards. Would really appreciate if i can get some help on this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count word in row to a particular date
    By Shamz41 in forum Excel General
    Replies: 4
    Last Post: 05-23-2017, 12:51 AM
  2. Count How Often Word Occurs in One Column Depending on Date Ranges
    By raeinla in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-18-2016, 05:56 PM
  3. Count word if date in other column is a specific month (July)
    By nicimcd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2015, 11:19 AM
  4. [SOLVED] Search and count a word (*delay*) from 3rd Column with multiple criteria from row/column
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2015, 06:00 PM
  5. help with date refrence
    By nartnart in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 05-15-2015, 02:25 AM
  6. [SOLVED] Need to count if Column A contains definded text and Column B equals defined word
    By JBlo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2014, 01:38 PM
  7. Replies: 3
    Last Post: 01-11-2012, 06:46 PM

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