Excel Magic Trick 1297

COUNTIFS & SUMPRODUCT & No Helper Column to Score Myers-Briggs Test


Learn how to Score Myers-Briggs Test from a Rectangular (Improper Lookup Table) with COUNTIFS Function with a Join Array Operation to create the OR Criteria Array that goes into the criteria argument& then the SUMPRODUCT function to add the output from COUNTIFS.


Download “Excel Magic Trick 1281-1300.zip” Excel-Magic-Trick-1281-1300.zip – Downloaded 1292 times – 4 MB

Be the first to comment

Leave a Reply