Seamus2626
asked on
Median with an IF
=MEDIAN(IF(Combined!I:I=AS P,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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
I assume you would also need to enter as an Array Formula using Ctrl + Shift + Enter.
Thanks
Rob H
Thanks
Rob H