MAX IF? - Return MAX if Condition met in Separate Column

[wx4usa]

I need a formula that will return the MAX value in Column A if these
column A numbers have "Active" in column B.

Column B is either Active or Inactive. Column A is age in days from
1-534.

Is there such a thing as MAX IF?

 

[JE McGimpsey]

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(B1:B1000="Active",A1:A1000))

 

[Guest]

try
=MAX((A1:A100)*(B1:B100="Active"))

entered with Cntrl+Shift+Enter or you'll get #VALUE

 

[Peo Sjoblom]

One way

=MAX(IF(B2:B100="Active",A2:A100))

entered with ctrl + shift & enter

(lookup array formula in help)