+ Reply to Thread
Results 1 to 3 of 3

Wrong formula or wrong function?

  1. #1
    Registered User
    Join Date
    05-30-2008
    Posts
    32

    Wrong formula or wrong function?

    I'm attempting to get a total of all "falls" that occurred in June between the hours of 0701-1100. My falls column has several versions of falls that can occur, my June column has dates (06/21/2017) and the times are entered as 07:01 AM. Unfortunately I can't attach my spreadsheet due to HIPAA. Here is the formula in it's current state, which is returning a #VALUE error:
    =SUMPRODUCT(Data!H2:H4000,">=7:01 AM",Data!H2:H4000,"<=11:00 AM")*(--(INT((MONTH(Data!$G$2:$G$4000)=6)*(ISNUMBER(SEARCH("Fall",Data!$D$2:$D$4000))))))

    What do I have wrong?
    Attached Files Attached Files
    Last edited by cpope; 09-11-2017 at 09:11 AM. Reason: attachment

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Wrong formula or wrong function?

    Can't say this will work for sure since there is no data available. But try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    05-30-2008
    Posts
    32

    Re: Wrong formula or wrong function?

    It is returning a 0 for the result, but the VALUE error is gone.

+ 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. What's wrong with this function?
    By elrastreador in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-17-2017, 01:39 PM
  2. [SOLVED] Can someone please tell me where I'm going wrong with this IF function formula?
    By centraltickets in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-29-2017, 05:28 AM
  3. [SOLVED] What's wrong with my function IF?
    By kara305 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2015, 02:05 AM
  4. Wrong coding or RANDBETWEEN is wrong?
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-31-2013, 10:01 AM
  5. What is wrong with this function?
    By idunham in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-19-2012, 10:51 AM
  6. Am I using the wrong function?
    By nowwecanmakewar in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-19-2007, 05:28 PM
  7. [SOLVED] What am I doing wrong with PMT function?
    By Marc in forum Excel General
    Replies: 6
    Last Post: 05-06-2006, 05: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