Results 1 to 4 of 4

CountIf/CountIFS/Sumproduct Not Displaying desired results.

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2019
    Location
    Orlando, Florida
    MS-Off Ver
    2013
    Posts
    19

    CountIf/CountIFS/Sumproduct Not Displaying desired results.

    I need to know the number of occurrences in a period of time in a certain interval (not sure yet but just need the base formula to work so I can adjust as needed). Every formula I have tried will only result in a 0 even though there are occurrences within the time period. These are the formulas that I have used:

    Formula: copy to clipboard
    =COUNTIFS(B1:B25,">=00:00",B1:B25,"<=00:30")


    Formula: copy to clipboard
    =SUMPRODUCT((D1:D12>=TIME(0,0,0))*(D1:D12<=TIME(0,30,0)))


    Formula: copy to clipboard
    =COUNTIF(D1:D12,">=00:00")-COUNTIF(D1:D12,">01:00")


    I am not sure why they are all returning 0's. The actual file has 713 cells to pull from.

    Any help is appreciated.

    Thanks,
    Attached Files Attached Files
    Last edited by shawnsdad; 10-26-2019 at 10:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Decimal not displaying as desired
    By JOB Dave in forum Excel General
    Replies: 3
    Last Post: 12-17-2017, 06:07 PM
  2. [SOLVED] Sumproduct to replace countifs as countifs don't work on external source reference
    By KrishnaSagar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-02-2017, 02:33 AM
  3. [SOLVED] Using COUNTIF or COUNTIFS rather than SUMPRODUCT
    By zanshin777 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-02-2016, 09:42 AM
  4. [SOLVED] need help displaying desired rows based on Yes and No question for multiple categories
    By DixieDoll11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2014, 01:48 PM
  5. CountiF or CountiFs two columns conditions or SUMPRODUCT
    By Oceans in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-01-2014, 03:02 PM
  6. [SOLVED] COUNTIF vs COUNTIFS vs SUMPRODUCT
    By FASTiger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2013, 01:44 AM
  7. comparing cells and displaying the desired value
    By phil@micro in forum Excel General
    Replies: 2
    Last Post: 01-23-2009, 05:32 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1