Hi Ron,

It works fine with named ranges when I test it.

--
Regards,

OssieMac


"Ron" wrote:

Hello all,

Does anyone know why this formula does not work with range names?

{=MAX(IF(NAME=A2,TransAmount,""))}

This works fine however, I have to adjust the range when adding data.

=MAX(IF('P-card
data'!$E$2:$E$7284=A2,'P-card data'!$F$2:$F$7284,""))

Thank you for your assistance, Ron
.