Results 1 to 12 of 12

Trouble with COUNTIFS() formula

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    Jersey
    MS-Off Ver
    Excel 2007/2010
    Posts
    10

    Trouble with COUNTIFS() formula

    I have a table that is formatted as so:

    PHP Code: 
        A           B                  C                     D
    1 Type    Timeinitial    Time ending           Total Time    
    2   8                                                  00
    :00            
    3   8                                                 00
    :00            
    4   5    7
    /29/2012 8:37    7/29/2012 8:55            00:18    
    5   5    8
    /4/2012 12:57    8/4/2012 13:06             00:09 
    There are a lot more rows below Row 5....

    I am trying to count each row where Type = 5, the total time is >00:00 and the month is August

    I wrote the following formula:

    =COUNTIFS(A2:A5, "5",D2:D5, ">00:00",C2:C5="mmmyyyy", "Aug2012")

    I keep getting a num error...any help of this formulate is deeply appreciated!
    Last edited by neoshaakti; 08-19-2013 at 08:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COUNTIFS OR...multiple countifs without duplication in the numbers
    By HooligaD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-21-2012, 09:53 AM
  2. [SOLVED] Countifs formula
    By lorber123 in forum Excel General
    Replies: 2
    Last Post: 09-25-2012, 12:44 PM
  3. Excel 2007 : Trouble with Countifs
    By jayres14 in forum Excel General
    Replies: 3
    Last Post: 03-09-2012, 09:51 AM
  4. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  5. Excel 2007 : COUNTIFS Formula
    By jhg1226 in forum Excel General
    Replies: 4
    Last Post: 05-02-2010, 11:40 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