MAX IF formula returns run time error

[maym]

I am sure this is relatively simple, but I am trying to combine Max and if and I want it to include the last row on my worksheet. So far I have used:

Please Login or Register  to view this content.

But this returns a run time error. What am I doing wrong?

Edit: Sorry, meant to post this in the VBA section.

[FlameRetired]

maym

Moderator note: I will move it for you.

[maym]

thank you

[jindon]

Mixing up xlA1 and R1C1 notation.
Perhaps.

Please Login or Register  to view this content.

[maym]

same error unfortunately. Inserting a hard number would work also if that is easier? E.g.

Please Login or Register  to view this content.

[jindon]

Ahhh, missing closing bracket at the end

Please Login or Register  to view this content.

[maym]

Yes, that worked! Thank you