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

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

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?
 
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(B1:B1000="Active",A1:A1000))
 
try
=MAX((A1:A100)*(B1:B100="Active"))

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

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

entered with ctrl + shift & enter

(lookup array formula in help)
 
Back
Top