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

netwsam

New member
Joined
Jan 14, 2015
Messages
4
Reaction score
0
Points
0
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
 
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))
 
Back
Top