Excel Magic Trick 344: MAX IF & RANK functions without Zeros R.Admin 7 years ago Excel Magic Trick 344: MAX IF & RANK functions without Zeros # Share this:Print How to Count only Positive values in a given rangeDateJuly 16, 2014In relation toExcel TipsExcel Magic Trick 810: RANKIF Function RANK IF: Ranking With ConditionsDateFebruary 23, 2017In relation toLearn ExcelHow to Excel Magic Trick 310: D Functions & Date CriteriaDateMarch 26, 2017In relation toLearn Excel