Using Pivot Table

An Excel file that teaches how to perform Using Pivot Table operation.

Excel Template for Using Pivot Table

Regular expression logic is simulated with formulas. Characters are examined in a discrete structure. Non-numeric characters are filtered out. Combined numbers are summed using array formulas. Errors return blank. The result is displayed in a single cell.

Hope it is useful.