Obtaining Max and Min Values with Sumproduct
 

Is this possible?

I have a data set of 4,000 lines and want to extract the maximum and
minimum values for Criteria3, where the conditions for Criteria1 and
Criteria2 are met.

I would be grateful for any assistance

tm


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=477898

Obtaining Max and Min Values with Sumproduct
 

=MIN(IF((A1:A10="a")*(B1:B10="b"),C1:C10))

entered with ctrl + shift & enter

do the same for MAX
--

Regards,

Peo Sjoblom

"Timmy Mac1" wrote
in message ...

Is this possible?

I have a data set of 4,000 lines and want to extract the maximum and
minimum values for Criteria3, where the conditions for Criteria1 and
Criteria2 are met.

I would be grateful for any assistance

tm


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=477898

Obtaining Max and Min Values with Sumproduct
 

Cheers Peo.

I get lost with array formulas and much prefer Sumproduct.

But I guess sometimes you can't avoid them :)

thanks again


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=477898