+ Reply to Thread
Results 1 to 4 of 4

Match activity to find times marked as 'y'

  1. 08-27-2018, 11:19 AM #1
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Match activity to find times marked as 'y'

    Hi guys, sorry to bother with this one, probably too simple for some of you just can't figure... May I please ask for a formula suggestion, as per screenshot and file below? Thanking in advance!

    https://www.excelforum.com/attachmen...1&d=1535383127 [EXCEL]

    2018-08-27_1714.png
    Attached Files Attached Files
    Last edited by vill; 08-27-2018 at 11:26 AM.
    Reply With QuoteRegister To Reply
  2. 08-27-2018, 11:31 AM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Match activity to find times marked as 'y'

    Try this in E2:

    =COUNTIFS(B:B,D2,C:C,"y")
    Reply With QuoteRegister To Reply
  3. 08-27-2018, 11:42 AM #3
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Match activity to find times marked as 'y'

    That was it 63falcondude, thanking you!!!!!!
    Reply With QuoteRegister To Reply
  4. 08-27-2018, 11:45 AM #4
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Match activity to find times marked as 'y'

    Happy to help. Thanks for the rep!
    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. Failed job interview because of lack of excel skills...
    By listerdl in forum Excel General
    Replies: 4
    Last Post: 08-17-2016, 10:37 AM
  2. =INDEX and =MATCH for a simple lookup?
    By Nate Westcott in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2015, 12:14 PM
  3. [SOLVED] Lack of understanding Index and match, and small formulas
    By lreed in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-10-2014, 11:37 AM
  4. vlookup and condition? matching employee's skills and Ticket skills
    By yannc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2014, 03:27 PM
  5. Simple Index Match formula giving me problems with 2 way lookup
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2013, 06:47 AM
  6. [SOLVED] Index match simple problem (horisontal lookup)
    By Ztv in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-09-2013, 05:07 AM
  7. simple lookup or match?
    By raehippychick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2007, 12:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1