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 <Ossie...@discussions.microsoft.com>
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 -