Excel Magic Trick 1297

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

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply