Hi guys,

Hope you can help me with this. I need to create a couple of median formulas for events based on the following criteria; however, I'm unsure of how to do this. Refer to attached dummy workbook.

Thanks in advance for you help. Really appreciate it.

Kind regards,

Charles

Hope you can help me with this. I need to create a couple of median formulas for events based on the following criteria; however, I'm unsure of how to do this. Refer to attached dummy workbook.

__First median formula required:__

- I want to find out the median of the event loss amounts (column G) for Australia (column D) with 'open' status (column N).
- I want a formula to
__include__the 'blank' cells in the median calculation and another formula to__exclude__the 'blank' cells in the median calculation. - Please note that some events will have identical loss amounts and some events will have loss amounts as 'blank' in the cell (
**NOT**represented by zero).

__Second median formula required:__- I want to find out the median of the event loss amounts (column G) for Australia (column D) only.
- I want a formula to
__include__the 'blank' cells in the median calculation and another formula to__exclude__the 'blank' cells in the median calculation. - Please note that some events will have identical loss amounts and some events will have loss amounts as 'blank' in the cell (
**NOT**represented by zero).

Thanks in advance for you help. Really appreciate it.

Kind regards,

Charles