+ Reply to Thread
Results 1 to 2 of 2

Count how many times a date in column G exceeds respective Row in Column A

  1. 06-14-2017, 03:43 PM #1
    tangerine7199
    tangerine7199 is offline
    Registered User
    Join Date
    11-09-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    7

    Count how many times a date in column G exceeds respective Row in Column A

    Hey there!

    I have dates in column G with respective due dates in column A. I would like to count how many times the date in Column G exceeds the respective date in Column A

    HTML Code: 
    I would like to have a cell that counts how many times G exceeds A, so in this case, 2.

    I tried COUNTIF(A4:A38,">"&G4:G38 and I got a zero.


    thank you
    laura
    Reply With QuoteRegister To Reply
  2. 06-14-2017, 04:44 PM #2
    CAntosh
    CAntosh is offline
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Count how many times a date in column G exceeds respective Row in Column A

    One possibility:

    =SUMPRODUCT(--(G4:G38>A4:A38))
    Last edited by CAntosh; 06-14-2017 at 04:46 PM. Reason: changed range to fit your effort above
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare two cells and count how many times either one exceeds 500
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-18-2017, 02:59 PM
  2. How to match a column of date times with a column of times (and corresponding data)?
    By jbody in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-19-2016, 02:40 PM
  3. [SOLVED] Count the number of times a value appears in one column whilst within a date from another
    By AntonSK in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2013, 08:08 AM
  4. [SOLVED] count the number of times each string appears in a column and make a summary column
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-04-2012, 08:02 AM
  5. Count number of times a date is over 3 years in a column
    By dcoates in forum Excel General
    Replies: 3
    Last Post: 08-22-2011, 11:58 AM
  6. How to count the number of times a date appears in a column
    By smellsgood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2010, 07:09 AM
  7. How to count the number of times a date appears in a column
    By smellsgood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2010, 06:35 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1