Sum text values like numbers in Excel

Sum text values like numbers in Excel

Please refer to the following procedure to sum text values like numbers in excel. 

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

There will be a separate table located to get the value using array vlookup formula.

Sample formula is as follows:

{=SUM(INDEX(K1:K3,N(IF(1,MATCH(A1:E1,J1:J3,0)))))}

J1:K3 is the table to refer. Where column K contains the numbers. J contains the text.

A1:E1: Text to check in column J. 

https://exceljet.net/formula/sum-text-values-like-numbers

About the author: admin

You must be logged in to post a comment.