+ Reply to Thread
Results 1 to 3 of 3

Count if adjacent cell to count falls within criteria or not

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    Count if adjacent cell to count falls within criteria or not

    Hi,

    I'm having a bit of a moment. I'll kick myself when you say the solution. Example attached.

    I have 3 columns of data - Start Date, End Date, Deadline.

    To get the info I want I have a fourth column titled "month" which I use for the criteria. From this I want to find out two things.

    1. How many End Dates fall in that "month" which I've done (Columne F)
    2. How many of those End Dates were equal to or less than the deadline column (yellow in example - column G)

    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Count if adjacent cell to count falls within criteria or not

    one option

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

  3. #3
    Forum Contributor
    Join Date
    03-05-2015
    Location
    norwich
    MS-Off Ver
    365
    Posts
    107

    Re: Count if adjacent cell to count falls within criteria or not

    You're a hero.

    Thank you!

+ 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] How to count a cell if it falls between two dates?
    By jgomez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2016, 04:18 PM
  2. [SOLVED] Count unique values if adjacent cell meets criteria
    By chococ in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2014, 04:13 AM
  3. Replies: 4
    Last Post: 09-12-2013, 11:32 PM
  4. [SOLVED] Count values in a range if adjacent cell meets a particular criteria
    By DougC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2013, 03:12 PM
  5. [SOLVED] count if date in another cell falls in certain month and year
    By ea223 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-18-2012, 07:17 PM
  6. sum non adjacent cells with multiple count criteria
    By icylemontea in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-20-2011, 04:13 AM
  7. Sum Count of Single Criteria in Multiple Non-Adjacent columns
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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