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?
Bookmarks