+ Reply to Thread
Results 1 to 4 of 4

using countif function

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    brisbane
    MS-Off Ver
    MS office 2007
    Posts
    4

    using countif function

    Hey,

    I have a small problem

    In column C we have the process list and status is in column D. By comparing the status I need the each process total list. please find the attachment for your reference. shall we use the countif function.

    Kiran
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: using countif function

    Hi,

    in K5 to be copied across

    =COUNTIFS($C$2:$C$20,$J5,$D$2:$D$20,K$4)

    Hope it helps
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: using countif function

    Please find attached file :D
    Attached Files Attached Files
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: using countif function

    Thanks for the feedback. :D

    If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

+ 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 function integrated with IF function
    By mamuka12 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 03-22-2013, 06:44 PM
  2. Replies: 9
    Last Post: 07-02-2012, 07:02 PM
  3. Using Countif Function with the Month & Year Function
    By laya1024 in forum Excel General
    Replies: 3
    Last Post: 02-03-2009, 07:52 PM
  4. [SOLVED] How do I use a countif function according to two other countif fu.
    By Kirsty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2006, 07:50 AM
  5. [SOLVED] Embed a countif function in subtotal function?
    By Stuck at work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2006, 11:20 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