Finding a max value.

[tactical]

See attached workbook. Pretty much I'm just trying to find the max value of column E for any given week.
Can anyone tell me what is wrong with my equation in F2?

Edit: I also am eventually going to go more in depth and try to find the max for any given week if c:c=130. I would assume I just need another if statement in there saying if(c:c=30,...

Thanks!

[Marcol]

The formula you are using is an array formula

=MAX(IF(A:A>=F1, IF(A:A<G1,E:E )))

Confirm with Ctrl+Shift+Enter not just Enter

[EDIT]
If you intend dragging right you will need

=MAX(IF($A:$A>=F1, IF($A:$A<G1,$E:$E )))

[ConneXionLost]

Try this:

=MAX((A1:A1000>=F1)*(A1:A1000<G1)*E1:E1000)

confrimed with Ctrl-Shift-Enter.

Cheers,

[tactical]

Okay, I got the first part. Thanks!! Now I'm trying to do what I posted in the edited comment. Any Insight?

[ConneXionLost]

Try:

=MAX((A1:A1000>=F1)*(A1:A1000<G1)*(C1:C1000=130)*E1:E1000)

again with CSE.

Cheers,