Suppose column A has deal value, column B has region. · To get median for EMEA only: In Sheets: =MEDIAN(FILTER(A2:A100, B2:B100="EMEA")) · FILTER first narrows ...