SUM or AVERAGE Text Values Like Numbers in Excel | Assign Numeric Value to Text and Sum or Average
34.8 هزار بار بازدید -
3 سال پیش
-
Download the featured file here:
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.
------------------------
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.
------------------------
3 سال پیش
در تاریخ 1400/07/20 منتشر شده
است.
34,818
بـار بازدید شده