Unable to get values to sum.
I can extract the values with:
=INDEX(IFNA(REGEXEXTRACT(Sheet1!A:A, "$(d+.d+|d+)")*1))
But I am not able to match them. In the images below, I want column D1 to pull all $ values from A:A, if the value in column B on Sheet1 matches the name in column A on sheet2, total the $ values indexed and print them into column D
(https://i.sstatic.net/e89orMPv.png)(https://i.sstatic.net/Da8EcJX4.png)
New contributor
Westley Stellete is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.