Announcement

Collapse
No announcement yet.

median value based on criteria in two other columns

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • median value based on criteria in two other columns



    Hi
    Need a formula to calculate: median of the numbers in column C thate are greater than "0" based on a specific criteria in column A and also specific month in column "B".

    eg: i want the median prices for the sales in mosman (multiple sububs in column) in april (multiple months in the column)

    spreadsheet attached

    thanks in advance for anyones help
    Attached Files

  • #2


    Re: median value based on criteria in two other columns

    Please do not create duplicate threads.

    You've already asked this question and received a reply in your other thread:

    Calculate median without zeros based on another column criteria


    Discussion may continue in your original thread.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

    Comment

    Working...
    X