Eric's formula works for me with MIN in it. There is however a surplus set
of brackets:

=SUMPRODUCT(MIN((B1:B6="Bob")*(C1:C6)))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"Red 61" wrote in message
...
Eric -- this worked GREAT for the MAX values -- but MIN always returns
zero.

If we can't figure out a way to do MIN, that's okay -- I'm happy with MAX.
:)

thanks,
Guy


"Eric" wrote:

Red,

You could also use:

=SUMPRODUCT( MAX( ((B1:B6)="Bob") * (C1:C6)))

Adjust the ranges, the name, and use either MIN or MAX as necessary.
This
doesn't require the CTRL+SHIFT+ENTER to enter.

Eric

"Red 61" wrote:

Hi there,

I am trying to find the minimum and maximum sales for each salesperson.
I
can not sort by salesperson -- I must sort by sales date. How do I do
this?

1/2/1999 Bob $7
1/5/1999 Rick $20
1/7/1999 Sue $75
1/10/1999 Bob $5
1/15/1999 Sue $3
1/27/1999 Rick $53

So, I need to know Bob's minimum sale was $5, and his maximum sale was
$7.

I know how to use the MIN and MAX functions, but how do I tie in the
sales
person name?