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

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

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. 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
•