Median with criteria

NateDizzle

Hello!

I am trying to get the median days to complete for anything that is Bank of America, Chase Bank, etc. etc..

I have tried using the entire column in the formula and also specifying the specific cells and both returned with errors.

The formulas I have used are the following:

=MEDIAN(COLLECT({Days to Complete}, {Current Custodian}, "BANK OF AMERICA N.A"))

=MEDIAN(COLLECT([Days to Complete]1:[Days to Complete]1136, [Current Custodian]1:[Current Custodian]1136, "BANK OF AMERICA N.A"))

Your help is greatly appreciated.

Paul Newcome

What errors are you getting with those formulas, and is the formula going on the same sheet as the source data or a different sheet?