Hi All,
I have trouble with excel sheet or the formula. I am trying to calculate Min with multiple conditions. The formula I am using is {=MIN(IF(Tier=3,IF(Location="USA",IF(LCount<>"",LCount))))}. If I use the formula on other sheets it works find but on this particular sheet it returns the wrong answer. I have attached the sheet to look at: Droplr • Sample.xlsx
<tbody>
</tbody>
I tried using Clean function to clean the cells but nothing happened. I also tried deleting named ranges and re adding them still no luck.
Please help.
Regards,
I have trouble with excel sheet or the formula. I am trying to calculate Min with multiple conditions. The formula I am using is {=MIN(IF(Tier=3,IF(Location="USA",IF(LCount<>"",LCount))))}. If I use the formula on other sheets it works find but on this particular sheet it returns the wrong answer. I have attached the sheet to look at: Droplr • Sample.xlsx
Region | Tier | Location Count | ||||||
Japan | 3 | |||||||
USA | 3 | 50 | Min = | 0 | ||||
Japan | 3 | Answer should be 26 and not 0 as above | ||||||
USA | 3 | 56 | ||||||
Japan | 3 | |||||||
USA | 3 | 696 | ||||||
Australia | 3 | |||||||
Australia | 3 | |||||||
USA | 3 | 306 | ||||||
USA | 3 | 26 |
<tbody>
</tbody>
I tried using Clean function to clean the cells but nothing happened. I also tried deleting named ranges and re adding them still no luck.
Please help.
Regards,