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.
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
Bookmarks