Results 1 to 2 of 2

Thread: How to maxif and minif with a criteria falling in a certain time of the day.

  1. #1

    Smile How to maxif and minif with a criteria falling in a certain time of the day.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I have a problem in related to maxif and minif. I searched thru the forum and worked out a formula like this:

    Worksheet 1 (WS1)
    Column A: date, time (Hour, Min, seconds)
    Column B: reaction time

    Worksheet 2 (WS2)
    Cell A1: 1/1/2015 6:00
    Cell A2: 1/1/2015 7:00
    Cell A3: 1/1/2015 8:00 etc...

    My objective is to find the (Maximum reaction time- Min reaction time) that falls between 1/1/2015 6:00 AM to 1/1/2015 7:00 AM
    For the max array: I tried the following but return with zero with all the entries???

    WS2 Cell B1=MAX(IF((WS1 Column A>WS2 A1)*(WS1 Column A<=WS2 A2), WS1 Column B))

    Does anyone know how to solve this problem??
    Thanks

  2. #2
    Your formula is right, but it must be array-entered, and I wouldn't use whole columns

    =MAX(IF((A2>='WS1'!$A$1:$A$1000)*(A1<'WS1'!$A$1:$A$1000),'WS1'!$B$1:$B$1000))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •