Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/09/Assign-Value-to-Text-and-Sum.xlsx

In this video I demonstrate how to sum or average text values as if they were numbers. The functions needed to achieve this are INDEX, MATCH, N and IF.

In Excel 365 you can convert numeric values to text using just INDEX and MATCH.

In earlier version of Excel you have to create an array formula using INDEX, MATCH, N and IF.
------------------------