Obtaining Max and Min Values with Sumproduct

T

Timmy Mac1

Is this possible?

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

I would be grateful for any assistance

t
 
P

Peo Sjoblom

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

entered with ctrl + shift & enter

do the same for MAX
 
T

Timmy Mac1

Cheers Peo.

I get lost with array formulas and much prefer Sumproduct.

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

thanks again
 
Top