Finding values in one column based on another

[RMB]

My spreadsheet has 13 columns. I need two formulas. One where the formula for finding the maximum value in column 13 when column B's entry is XX and one where it does the same thing but only if the number in colum 1 is <= 100 (any specific number).

[Domenic]

Try the following...

=MAX(IF(B1:B100="xx",M1:M100))

and

=MAX(IF((A1:A100<=100)*(B1:B100="xx"),M1:M100))

or

=MAX(IF((A1:A100<=C1)*(B1:B100=D1),M1:M100))

...where C1 contains your criterion for Column A, and D1 contains your criterion for Column B.

Both these formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

My spreadsheet has 13 columns. I need two formulas. One where the formula for finding the maximum value in column 13 when column B's entry is XX and one where it does the same thing but only if the number in colum 1 is <= 100 (any specific number).