Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Median with an IF

=MEDIAN(IF(Combined!I:I=ASP,Combined!R:R))

Thats my formula, im getting a name error

Im trying to get the median of the amounts in Col R if the corresponding entry in I = ASP

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Phillip Burton
Phillip Burton

It should also be done as an array formula, so instead of pressing Return at the end of the formula, you should press Shift+Ctrl+Enter.
Avatar of Rob Henson
I assume you would also need to enter as an Array Formula using Ctrl + Shift + Enter.

Thanks
Rob H