+ Reply to Thread
Results 1 to 3 of 3

I want to count data which need to match two value

  1. #1
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    118

    I want to count data which need to match two value

    Hello All,

    I try to use If fuction and countifs but it dones't work, please help me as below:

    Column A: row 1-5 contains 1 Fe, 3 Feb,5 Feb, 4 Mar, 2 Apr, 2 May
    Column B: (perfomance) 1 Feb = ontime, 3 Feb = late,5 Feb = ontime, 4 Mar = ontime, 1 Apr = ontime, 2 May = late

    Column C: I want ( how many ontime of each month, Like ( Feb ontime 2, Mar 1 and Apr 1)

    Please help to advice which formulas I can use.

    Thanks you so much in advance.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: I want to count data which need to match two value

    in C1
    Feb
    and put the other months going down Mar Apr May

    in D1
    =SUMPRODUCT(--(TEXT(A1:A6,"mmm")=C1)*(B1:B6="Ontime"))
    and copy down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    03-05-2015
    Location
    Cambodia
    MS-Off Ver
    2016
    Posts
    118

    Re: I want to count data which need to match two value

    Hello,

    I don't know how to express my feeling now :D , but I would like to say it such a great help .

    Thank you so much on this formulas.

    Wish you all the best

+ 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] Using Countifs/Match/Index formula to count data in different columns
    By satania in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-09-2023, 04:00 AM
  2. [SOLVED] Need to count items in column that match multiple data items
    By bclucas55 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 10:03 AM
  3. [SOLVED] Looking for formula to count and match data.
    By fulldeen in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-16-2012, 08:25 AM
  4. Replies: 2
    Last Post: 06-07-2012, 07:03 AM
  5. [SOLVED] Problem with INDEX, MATCH, and a function to count data from a table
    By Pentasyllabic in forum Excel General
    Replies: 10
    Last Post: 05-22-2012, 05:16 PM

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