Finding the Numbers That Make Up the Total

An Excel file that teaches how to perform Finding the Numbers That Make Up the Total operation.

Excel Template for Finding the Numbers That Make Up the Total

The target total is indicated at the top of the table. Combinations are checked using a formula. Matching rows are separated using a filter. Automatic calculations are performed using array functions. Results are reflected in the summary table.

Hope it is useful.