Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test R.Admin 7 years ago Excel Magic Trick 1297: COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test # Share this:Print Excel Count FunctionsDateAugust 27, 2014In relation toSmart Excel Tips9 Tips to Write Lookup Formulas More Effectively – Excel TipDateJanuary 28, 2016In relation toAdvanced Excel TipsHow to Use COUNTIFS() to Evaluate Multiple Count and Criteria RangesDateJuly 24, 2014In relation toExcel Tips