If statement to look up a specified Range and Average just that specified range

[zachenson]

I am wondering if anyone has any thoughts on how to do this? I am trying to show an average of all the data in range B72:B500, for the time period specified in the range A23:A68 and shown in range F72:F500, for the day specified in row 20 and shown in range A72:A500.

So basically i'm trying to say for this 30 minute time period, on this day, the average "Tick Move Direction" was "X".

If anyone has any thoughts I where to start I would so so appreciate it.

 

[Gerald Higgins]

Hi, welcome to the board.

Your request is hopelessly confusing.

What EXACTLY do you want to do ?

Don't worry about explaining the background to all this, just focus on the data you actually have, and what you want to do with it.

Can you post a small example of what the results SHOULD be, with the data you have given ?

ALSO, it looks as if you want to use Column A as one of your criteria, and this contains days, not dates.
Is the Wednesday on row 73 the same day as the Wednesday on row 92 ?
And if not, how do you want to deal with that ?