Hi team, I have a median formula that is removing zero's nicely and is providing a median age.
{=MEDIAN(IF(E383:DA383<>0,$E$10:$DA$10))}
The issue is it seems to also be counting the corresponding ages e10:da10 even if the corresponding row has a zero
ie sales assistants is returning median age of 49.5 instead of around age 25
Col DA is 115yo
There are 487 rows so i would prefer not to do this manually
TIA for assistance
Hopefully to do without a macro as I know nothing about macrs's
{=MEDIAN(IF(E383:DA383<>0,$E$10:$DA$10))}
The issue is it seems to also be counting the corresponding ages e10:da10 even if the corresponding row has a zero
ie sales assistants is returning median age of 49.5 instead of around age 25
Col DA is 115yo
There are 487 rows so i would prefer not to do this manually
TIA for assistance
Hopefully to do without a macro as I know nothing about macrs's
Attachments
Last edited: