SUM or AVERAGE Text Values Like Numbers in Excel | Assign Numeric Value to Text and Sum or Average
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...
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.
------------------------