Download Excel File: [ Ссылка ]
Learn how to add the text numbers at the end of a description to get a Sales Total using Excel worksheet formulas or Power Query Formulas. Extract Numbers from end of Description Trick.
Topics:
1. (00:00) Introduction
2. (00:14) Excel Worksheet Formula.See SUBSTITUTE, REPT, LEN, RIGHT and SUM worksheet functions.
3. (02:40) Power Query Formulas. See Query Editor Steps, Field Access Operator, and the List.Sum Power Query M Code Function.
4. (04:32) What happens when we get new data?
5. (04:47) Closing and Video Links
