+ Reply to Thread
Results 1 to 4 of 4

Countif,Match

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Germany
    MS-Off Ver
    MS 2011
    Posts
    11

    Countif,Match

    Screen Shot 2014-09-29 at 11.24.44 PM.png
    I have 365 days of the year and I want to find the exact day when a car will be returned. I found how to do it.However,if a car is available at day 13 and on the next day another car is available at day 13,with MATCH function I get just 1.I want to be counted,so that at day 13 I have 2. At some days there are no returns of cars,so we have this empty.However,when it is empty,the MATCH function treats it as #N/A.Is it possible instead of #N/A to have 0 showing.

    The formula which I used: =IF(MATCH(A3,$B$2:$B$366,0)>0,1,0)

    There is also an attachment. I will truly appreciate all of your help

    Thank you very much

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Countif,Match

    Instead use:

    =SUMPRODUCT(--(A3=$B$2:$B$366))

    This is the count of the matches.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    09-29-2014
    Location
    Germany
    MS-Off Ver
    MS 2011
    Posts
    11

    Re: Countif,Match

    It worked perfect. Thank you so much for your help

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countif,Match

    This should also work:

    =COUNTIF(B$2:B$366,A3)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Countif/Match Index
    By skate1991 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2013, 12:43 PM
  2. [SOLVED] How - Match/If/Countif
    By Shermaine2010 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2013, 09:30 PM
  3. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  4. if. match, countif HELP!
    By CHRISB37 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2012, 06:56 PM
  5. Match & Countif
    By Killer17 in forum Excel General
    Replies: 4
    Last Post: 12-10-2010, 05:36 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