Find MAX for sumproduct

[Mike]

Good evening...
I have the formula: =SUMPRODUCT((B1:B5)*(A1:A5="baltimore")) to give the
sum of numbers that match Baltimore.
e.g.:

A B
--------------------------------
1. New York 85
2. Baltimore 33
3. New York 38
4. New York 77
5. Baltimore 45

I want to write the formula to find the largest (MAX) number that matches
Baltimore, in this case 45.

Any help would be appreciated.

Mike

[Max]

Good morning ! (It's already 9 am, 29 Apr over here <g>)

Try, array-entered (Press CTRL+SHIFT+ENTER):
=MAX(IF($A$1:$A$5="Baltimore",$B$1:$B$5))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mike" <windme@cox.net> wrote in message news:zvfce.40$%44.0@lakeread06...
> Good evening...
> I have the formula: =SUMPRODUCT((B1:B5)*(A1:A5="baltimore")) to give the
> sum of numbers that match Baltimore.
> e.g.:
>
> A B
> --------------------------------
> 1. New York 85
> 2. Baltimore 33
> 3. New York 38
> 4. New York 77
> 5. Baltimore 45
>
> I want to write the formula to find the largest (MAX) number that matches
> Baltimore, in this case 45.
>
> Any help would be appreciated.
>
> Mike
>
>

[Mike]

Thanks Max, works great!!
Mike
"Max" <demechanik@yahoo.com> wrote in message
news:O9035bFTFHA.1148@tk2msftngp13.phx.gbl...
> Good morning ! (It's already 9 am, 29 Apr over here <g>)
>
> Try, array-entered (Press CTRL+SHIFT+ENTER):
> =MAX(IF($A$1:$A$5="Baltimore",$B$1:$B$5))
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "Mike" <windme@cox.net> wrote in message news:zvfce.40$%44.0@lakeread06...
>> Good evening...
>> I have the formula: =SUMPRODUCT((B1:B5)*(A1:A5="baltimore")) to give the
>> sum of numbers that match Baltimore.
>> e.g.:
>>
>> A B
>> --------------------------------
>> 1. New York 85
>> 2. Baltimore 33
>> 3. New York 38
>> 4. New York 77
>> 5. Baltimore 45
>>
>> I want to write the formula to find the largest (MAX) number that matches
>> Baltimore, in this case 45.
>>
>> Any help would be appreciated.
>>
>> Mike
>>
>>
>
>

[Max]

You're welcome !
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Mike" <windme@cox.net> wrote in message news:A1gce.45$%44.11@lakeread06...
> Thanks Max, works great!!
> Mike