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

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?

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

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

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

In article .com,
wx4usa wrote:

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?

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

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

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


"wx4usa" wrote:

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?

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

One way

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

entered with ctrl + shift & enter

(lookup array formula in help)


--

Regards,

Peo Sjoblom




"wx4usa" wrote in message
oups.com...
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?