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

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
.

Thanks OzzieMac.... I think I had a bad reference. After reworking
and rechecking it works fine. Thank you for taking your time and
assistance with my project. Ron


On Mar 1, 10:18*pm, OssieMac
wrote:
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
.- Hide quoted text -

- Show quoted text -