+ Reply to Thread
Results 1 to 3 of 3

Count closed work orders

  1. 09-11-2009, 12:17 PM #1
    mikesjd110
    mikesjd110 is offline
    Registered User
    Join Date
    06-19-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Count closed work orders

    Hey everyone,

    I need to count the amount of work orders that my employees have completed. Review example...
    How many work orders did chuck complete? (Column D)
    How many work orders did brian complete?
    Attached Images Attached Images
    Last edited by mikesjd110; 09-11-2009 at 12:26 PM. Reason: Closed
    Reply With QuoteRegister To Reply
  2. 09-11-2009, 12:20 PM #2
    DonkeyOte
    DonkeyOte is offline
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Count closed work orders

    Hmm... sounds a bit like homework...

    Completed Work Orders:

    =COUNT(D3:D12)

    Completed Work Orders by Chuck - assuming XL2007

    =COUNTIFS(B3:B12,"Chuck",D3:D12,">0")

    I think you can work out Brian ?
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With QuoteRegister To Reply
  3. 09-11-2009, 12:24 PM #3
    mikesjd110
    mikesjd110 is offline
    Registered User
    Join Date
    06-19-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Count closed work orders

    Thanks DonkeyOte
    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)

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