+ Reply to Thread
Results 1 to 2 of 2

Countif formula help

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    1

    Countif formula help

    Hi,

    I'm hoping someone can help.

    I'm trying to add a formula which will count the number of cells where the following is true:

    Column D = "3"
    Column G has a date input which is before a date in cell G13

    Hope this makes sense!!

    I've tried:
    =COUNTIFS(D16:D40,3,G16:G40,"<G13")

    But, when i've added the 3 to column D and the date stated in column G is before the date in G13 - the cell shows a '0' instead of a '1'

    I am using another formula to find the date in G13 - could that be an issue?

    Thank you in advance for any help you can offer me!

    Lisa

  2. #2
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Countif formula help

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

    Cheers
    <-- If you're happy & you know it...click the star.:-)

+ 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] CountIf formula results in the formula itself being displayed.
    By NewKid in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-19-2017, 03:31 PM
  2. Faster if/countif formula for flagging uniques - countif too slow
    By Speshul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2015, 01:44 PM
  3. [SOLVED] Using Countif formula on cells that have a Left formula
    By fsoares22 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2013, 11:13 AM
  4. [SOLVED] =Subtotal(countif,Range); Subtotal and countif in 1 formula [SOLVED]
    By thomas.mapua in forum Excel General
    Replies: 5
    Last Post: 01-06-2012, 11:33 AM
  5. Adding a CountIF to a formula that is already Countif
    By Cmorgan in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 09:34 AM
  6. Formula for COUNTIF using AND
    By astetler in forum Excel General
    Replies: 5
    Last Post: 05-13-2011, 10:31 AM
  7. Excel 2007 : The COUNTIF formula???
    By Ricky1974 in forum Excel General
    Replies: 2
    Last Post: 07-15-2010, 08:56 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