MAXIF and MINIF function

[Granger]

I have seen this question come up a couple times but I have not been
able to get the solutions to work. Here is my problem:

I have a list of part numbers on one sheet in col. A. In Col B I have
a countif formula that returns the total number of times that part
number occurs(jobs listed on sheet 2). This tells me the number of
times this part has been run. In col C I have a sumif formula that
returns the total of the average part cost(on sheet 2). In col D I
have a simple C2/B2 formula that tell me the average cost to run the
part. Now the problem. I need to show the maximum it cost to run
this part and the minimum it cost to run this part. Without a
maxif/minif formula I am stuck. Any suggestions?

Here is how my data is arranged:

SHEET 1

"Col A" = Part Number, "Col B" = Number of Runs, "COL C" = Total of
labor per part", "COL D" =Average Part Cost, "COL E" =Max, "COL F" =
Min


SHEET 2

"COL C" = part number, "COL N" = Labor per part


IF there was a MAX if formula I would want it to return the highest
number from Sheet 2 for each part number listed.

Please let me know if I need to provide more detail.

Thanks in advance for your help!!!!

-Granger

 

[Peo Sjoblom]

=MAX(IF('Sheet2'!A2:A100="ABC",'Sheet2'!B2:B100))

entered with ctrl + shift & enter

will return the highest number in B where A is "ABC"